Datasheet Form

[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

 

[Guest]

Is the button on a form or on the switchboard?
What is the code in the button's Click event?

 

[fredg]

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

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

 

[Guest]

Setting the form to open as asFormDS solved my problem.

Thanks for the help again,

Paul