Chage from Single Form to Data Sheet

G

Greg

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.
 
O

Ofer

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

Docmd.OpenForm "FormName", acFormDS
 
N

Neil M

thanks thats seemed to work just by adding the acFormDS to it -
don't know how I missed it - thanks.
 
G

Greg

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...
 
Top