On Mon, 7 Nov 2005 20:38:05 -0800, Mouse wrote:
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6899
> Switchboard it still opens them in Form view. How can I stop this from
If you open a form from an event, regardless of the default viewReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6899
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.
Private Function HandleButtonClick(intBtn As Integer)
A few lines down you'll find the Constants listed.
Const conCmdOpenFormDS = 9
at the end of the list (I believe there are originally just 8
Then go down further into the Select Case statements.
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.
Please respond only to this newsgroup.
I do not reply to personal e-mail