Opening Form in Datasheet View

[Guest]

Hi, I have a database that tracks visitors to our plant and their safety
orientation dates. I have created a query (and a corresponding form) that
allows the user to search for a person by their last name or part of it. I
want the results of the search to open the form in datasheet view so that
the user can see all visitors with last names starting with one letter or two
letters whatever the case may be. I used the Switchboard Manager to have the
form open from the Main Switchboard page. I set the Default view to
Datasheet and Form View to NO, Data Entry Allowed to no on the form. I get
the results expected except the form keeps appearing in form view no matter
what I try. What is going on?

Carla

 

[Douglas J. Steele]

When you use DoCmd.OpenForm, the form will always open in Form view. Just
use the acFormDS parameters:

DoCmd.OpenForm "NameOfForm", acFormDS

 

[Joan Wild]

For details on how to modify the Switchboard Manager's take on this see
http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html#datasheet--Joan WildMicrosoft Access MVP