Form Default View - Datasheet

[Peter]

Hi All..

I have set the Form Properties to Default View, i have only alouded (yes)
Allow Datasheet View...but every time i open a form from a commandbutton..i
is in form view...and i only want the form to be in Datasheet view...

Thanks!

 

[Allen Browne]

You must specify the view in the code/macro that opens the form (the code in
the Click event of your button.)

Something like this:
DoCmd.OpenForm "Form1", acFormDS

 

[Peter]

Thank you Allen, works nice!

You must specify the view in the code/macro that opens the form (the code in
the Click event of your button.)

Something like this:
DoCmd.OpenForm "Form1", acFormDS