Form will not open in data sheet view

[Guest]

I am trying to set up a button to open a form in datasheet view, and I have
datasheet set on the property table of the form. But when I try to use a
command button it opens in form view -

Any suggestions?

 

[Dirk Goldgar]

I am trying to set up a button to open a form in datasheet view, and
I have datasheet set on the property table of the form. But when I
try to use a command button it opens in form view -

Any suggestions?

Regardless of what the form's default view is, your button's code must
explicitly tell the form to open in datasheet view. For example,

DoCmd.OpenForm "MyForm", acFormDS

 

[Guest]

Thank you it works.
--
Lynette

Regardless of what the form's default view is, your button's code must
explicitly tell the form to open in datasheet view. For example,

DoCmd.OpenForm "MyForm", acFormDS

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)