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
 

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

Similar Threads

Unremovable horizontal scroll bar on subform 1
Open a form in filter by form datasheet view from Switchboard 5
Sync/Link 2 forms 2
Form Default View - Datasheet 2
specifying which subdatasheet in Access 2003 3
How to open form in datasheet view from the switchboard? 4
Opening a form from switchboard 7
open form in datasheet view 7

Back
Top