Datasheet view

G

Grace

I have a button that I've placed on a subform that when
pressed opens a form. The form is set to display in
datasheet view. However, when I the form is opened using
the navigation button, it opens in single form view.

Any thoughts?
 
R

Rick Brandt

Grace said:
I have a button that I've placed on a subform that when
pressed opens a form. The form is set to display in
datasheet view. However, when I the form is opened using
the navigation button, it opens in single form view.
Click to expand...

You have to use the FormView argument of the OpenForm method to explicitly
indicate you want Datasheet view

DoCmd.OpenForm "someform", acFormDS
 
T

Tom Ross

Or you can make a macro to open the form and specify the view in the macro
editor.
 
Top