Forms - Datasheet view (MS 2003) (1 Viewer)

[johnb19]

Have created a form to display/change table info in Datasheet View and added the form to a switchboard.
Problem: When selected from switchboard, it displays a single record. When executed from the Forms (objects), it displays in Datasheet view. ???

How can I get it to display in Datasheet View from Switchboard?

________________________________________________
Default view = Datasheet
Allow Form View = Yes
Allow Datasheet View = Yes

Thanks for any help.

JB

 

[MarkK]

How do you open the form? If you use use DoCmd.OpenForm, pay closer attention to the second parameter, called "View," and provide the correct value for the view you want.
hth