Chage from Single Form to Data Sheet

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

Guest

I have a command button opening a form which in the properties is default set
to Data Sheet View, but when opening i get the Single Form View.

How can i force data sheet view?

Greg.
 
In the Open form command line you can define the sort of view

Docmd.OpenForm "FormName", acFormDS
 
thanks thats seemed to work just by adding the acFormDS to it -
don't know how I missed it - thanks.
 
Thanks for that, your help is appreciated.



Ofer said:
In the Open form command line you can define the sort of view

Docmd.OpenForm "FormName", acFormDS

--
The next line is only relevant to Microsoft''s web-based interface users.
If I answered your question, please mark it as an answer. It''s useful to
know that my answer was helpful
HTH, good luck
Click to expand...
 
Back
Top