Datasheet view

[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?

 

[Rick Brandt]

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.

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

DoCmd.OpenForm "someform", acFormDS

 

[Tom Ross]

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

 

[Tom Ross]

Sorry. I misread your question. This solves a different problem