Open Form in Datasheet view from Switchboard

M

Mouse

I have designed a pretty basic database which uses the Switchboard. Some of
the forms I have create I want to only open in Datasheet view (not form
view). I have modified the details in the forms properties which works from
the Forms view of Access. However when I launch these forms from the
Switchboard it still opens them in Form view. How can I stop this from
happening?
 
F

fredg

I have designed a pretty basic database which uses the Switchboard. Some of
the forms I have create I want to only open in Datasheet view (not form
view). I have modified the details in the forms properties which works from
the Forms view of Access. However when I launch these forms from the
Switchboard it still opens them in Form view. How can I stop this from
happening?

If you open a form from an event, regardless of the default view
settings of the form, you must specify datasheet view:
DoCmd.OpenForm "FormName", acFormDS

This is easy to do if your switchboard is one you created yourself.
Just add the ,acFormDS to the OpenForm code, as above.
However, if your switchboard is one created by the built in Access
Switchboard manager, you'll need to go into the code to modify it.

Open the Switchboard Code window.

Find the
Private Function HandleButtonClick(intBtn As Integer)
code line.
A few lines down you'll find the Constants listed.
Add
Const conCmdOpenFormDS = 9
at the end of the list (I believe there are originally just 8
constants).

Then go down further into the Select Case statements.
Add
Case conCmdOpenFormDS
DoCmd.OpenForm rst!Argument, acFormDS
just before the Case Else statement.

Close the code window.

Open the Switchboard Items table.
Change the Command value for the form you wish to
open from it's current number (either 2 or 3) to 9.

That should do it.
You cannot make or edit this changes using the Switchboard manager.
You must work around it, as above.
 

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