I have created several forms to open in Datasheet View. When I open any of these forms from either another form or the switchboard, only one record shows. I have to select View and Datasheet View before I get what I want. Can someone tell me how to get the datasheet view the first time?

Hi,

First of all is the default view for your forms set to Datasheet? If it is then you could create a macro that will run the OpenView action and here you can set the view to datasheet. Attach this macro to your form's OnOpen event

Try it out and see how it goes.

Rob

Unless you want to modify the built in switchboard form (not recommended), you'll have to open the form with a macro. Then change the switchboard option to run the macro rather than opening the form. The standard switchboard does not give you the option to open a form in datasheet view. So, this is the workaround.