Can't Open Form in Datasheet View with Command Button

F

Fred Worthington

Greetings:

I have set the default view of my form to Datasheet View, and that is the
way it appears when opened from the database window. However, when I open
the form from a Command Button, it always opens in Form View. How can I get
the form to open in Datasheet View from the Command Button. Any suggestions
would be greatly appreciated.

Thanks . . . Fred
 
R

Rick Brandt

Fred Worthington said:
Greetings:

I have set the default view of my form to Datasheet View, and that is the
way it appears when opened from the database window. However, when I open
the form from a Command Button, it always opens in Form View. How can I get
the form to open in Datasheet View from the Command Button. Any suggestions
would be greatly appreciated.
Click to expand...

DoCmd.OpenForm "FormName", acFormDS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unremovable horizontal scroll bar on subform 1
Command Button with datasheet view 3
form control button does not open form as datasheet 1
Datasheet View 3
Sync/Link 2 forms 2
Can a Table be opened in datasheet view from a form 1
Changing the view. 4
open form in datasheet view 7

Top