Form in Datasheet view

[Pete]

I have a button on a form that opens another form. Is
there a way for the form to automatically open in
Datasheet view when I click the button? Any advice would
be great. thanks, pete.

 

[Cheryl Fischer]

You can set the form's Default View property to Datasheet.

 

[pete]

I have the default view set to Datasheet. The form opens
properly when i just open it. but when i try and use a
button in another form to open it, it opens in form view.

 

[Cheryl Fischer]

In the code behind that button in another form, you can use the View
argument :

DoCmd.OpenForm "MyForm", acFormDS

to control more explicitly how you want that form to open.

 

[Tom Stoddard]

In the openform method of the DoCmd object the second argument is the View
argument. I believe that if you specify acFormDS as the view argument the
form will open in datasheet view.

 

[pete]

That worked perfectly. thanks alot!

-----Original Message-----
In the openform method of the DoCmd object the second argument is the View
argument. I believe that if you specify acFormDS as the view argument the
form will open in datasheet view.




.