Datasheet default

[Guest]

Running simple switchboard, forgot how to set view of form to Datasheet?
Also forgot how to minimize in the same switchboard, the data table, etc.

 

[Guest]

It depends on how you are opening your form from the switchboard. If using a
macro, make sure that the OpenForm Action includes the Datasheet View in the
lower window. If opening using VBA code, using something like this:

DoCmd.OpenForm "Customers", View:=acFormDS

Substitute Customers with the actual name of your form.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Joan Wild]

If you are using the built-in switchboard manager, have a look at the following:
http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html