Datasheet Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a datasheet form. When I open the form from the Database
Window the form opens in a datasheet view.

I have a button that opens the same form but when clicked the form opens in
a single form view.

The default view is set to Datasheet.

Is there a way to get the form to open in datasheet view when clicking the
button.

Thanks for the help,

Paul
 
Is the button on a form or on the switchboard?
What is the code in the button's Click event?
 
I have created a datasheet form. When I open the form from the Database
Window the form opens in a datasheet view.

I have a button that opens the same form but when clicked the form opens in
a single form view.

The default view is set to Datasheet.

Is there a way to get the form to open in datasheet view when clicking the
button.

Thanks for the help,

Paul
Click to expand...

Regardless of the form's Default View setting, to open a form in
datasheet view using code you MUST specify datasheet view:

DoCmd.OpenForm "FormName", acFormDS
 
Back
Top