Force Datasheet View

[jschneider998]

Hi

I have several forms in my database that I have created as Datasheet view only. I have changed the property settings on each one to only allow datasheet views. When I created a command button on the main menu to open these forms, they open in form view....is there another way I can force them to open as datasheet view?

Thanks

 

[IMO]

In the Click event of your button...

    DoCmd.OpenForm "NameOfYourForm", acFormDS

IMO

 

[JSDART]

Thank you

Thanks I was experiencing the same problem and your solution was aces.
J