opening a form is datasheet view from a switchboard

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

Guest

Everytime i use a switchboard to open a form it opens the form n single form
view even though I have set the defualt view on the form to datasheet view.
Any solutions?
 
You need to specify an optional argument of 3 to get this effect:
DoCmd.OpenForm "Form1", acFormDS
 
Thanks Allen - where does the 3 come in - or do I just use the code you have
included in your response?
 
The constant acFormDS has the value 3.

In code, you can just use the line posted (replacing Form1 with the name of
your form).

If you are trying to store the parameters in a table, use the value 3.
 
Back
Top