Access 2003 Forms

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.
 
G

Guest

In the Open Form command line add the acFormDS to the form view

docmd.OpenForm "MyformName",acFormDS
 
G

Guest

Now you see why I don't use the Switchboard.

The VBA code would be:
DoCdm.OpenForm "MyFormName", acFormDS
 
G

Guest

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

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

Top