Form opens in wrong view

[gar]

I have just created a "switchboard" for the first time but I have
encountered a problem. If I invoke a certain form by double clicking the


relevant entry in the navigation pane, the form opens in database view which is
the default view as per the form property sheet. If, on the other hand, I
invoke the same form from the switchboard, it opens in form view despite the
fact that form view is explicitly disallowed in the property sheet. I would be grateful for any help with this.

[June7]

Did you use switchboard wizard? I have never used it, don't like switchboard - it uses macros and I don't use macros. I suspect the macro code is specifying form view which overrides the property setting.

[Missinglinq]

When using DoCmd.OpenForm, to open one Form from another, as you're doing (a Switchboard is just a simplified Form) you have to use the syntax

DoCmd.OpenForm "YourFormName", acFormDS

to open the Form in Datasheet View...even if Datasheet is the Default View!

If, as June7 guessed, you are, in fact using the Switchboard Wizard, it doesn't use this parameter in the syntax for either of the two choices it gives you, for opening Forms.

The Switchboard Wizard is very rigid in how it does things, such as opening Forms, which is why very few experienced developers use it; most of us simply 'roll our own,' using a standard Form.

Linq ;0)>

[gar]

Thanks very much for your help; making some progress now.