form always opens in form view from switchboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form set to datasheet view only but when I open it from the
switchboard it always changes it to form view. Can I change this? In the
forms properties format tab under "Allow ...." I've only got the datasheet
view turned to YES.

Thx.
 
Ian said:
I have a form set to datasheet view only but when I open it from the
switchboard it always changes it to form view. Can I change this? In the
forms properties format tab under "Allow ...." I've only got the datasheet
view turned to YES.
Click to expand...

For some silly reason...

DoCmd.OpenForm "FormName"

....will open a form in its default view UNLESS that default view is Datasheet.
You have to explicitly specify datasheet view as an argument.

DoCmd.OpenForm "FormName", acFormDS
 
Thnaks -- worked for a subform button on a main form but where do I find that
code from the switchboard?
 
Ian said:
Thnaks -- worked for a subform button on a main form but where do I find that
code from the switchboard?
Click to expand...

Not sure. I never use the built in switchboard.
 
Back
Top