Form Default View - Datasheet

P

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!
 
A

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
 
P

Peter

Thank you Allen, works nice!

Allen Browne said:
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
 

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

Top