Access 2003 Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set my form properties to allow datasheet view and not allow single
form view. When I use a command button to open the form from a switchboard,
the form opens in single form view, not datasheet. Is there a way to force
datasheet view with out using a macro. If you could give me an example in VBA
that would be great.
 
In the Open Form command line add the acFormDS to the form view

docmd.OpenForm "MyformName",acFormDS
 
Now you see why I don't use the Switchboard.

The VBA code would be:
DoCdm.OpenForm "MyFormName", acFormDS
 
I have the same problem, but I don't understand the VBA instructions. Would
anyone be kind enough to walk me in baby steps through those, or a macro?
Thank you in advance!

Jen
 
Back
Top