Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

How to make a subform always show up as a form, not a datasheet?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rachel Garrett - 07 May 2008 07:49 GMT
I've had forms with subforms before, and when I created them through
the Form Wizard, the subform always showed up as whatever I picked. If
I picked datasheet, it stayed a datasheet. If I picked columnar/
tabular (I forget which), the subform stayed in that format.

Now I have a subform that I added by dragging a table on to the form
and using the resulting wizard to make the associations. In Design
View, this subform shows up like a form. But when I switch to Form
View, it turns into a datasheet. I know that I can get it back by
going to View >> Subform >> Form. But other people will also be using
this form, and I need to make it be Form by default. What property or
setting can I change to make this happen?

Thanks in advance.

--Rachel
Jeanette Cunningham - 07 May 2008 09:59 GMT
Rachel,
a form has a property called 'Allow datasheet view'
You can set it to No, and set 'Allow form view' to Yes.

Jeanette Cunningham -- Melbourne Victoria Australia

> I've had forms with subforms before, and when I created them through
> the Form Wizard, the subform always showed up as whatever I picked. If
[quoted text clipped - 12 lines]
>
> --Rachel
Rachel Garrett - 07 May 2008 14:24 GMT
Thanks, Jeanette. Where can this property be set? It isn't in any of
the Properties tabs.

--Rachel
Rachel Garrett - 07 May 2008 14:28 GMT
Wait a sec...looks like some properties are accessible through right-
clicking and saying "Properties", and other properties are accessible
through going through the menu. Most of the fields are the same, but
the menu has a few more. Wacky fun!

--Rachel
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.