creating a form

[homezone]

I'm creating a switchboard using an unbound form. I have a command button to
open a form. I want the form to open in datasheet view, but it's opening in
form view. How do I get it to open in datasheet view? Any help would be
deeply appreciated. Thanks

 

[Ed Robichaud]

Open your form in design view, select "properties", then set the default and
allowable form styles.

 

[homezone]

I've tried that and everything else I can think of, but it is still opening
in form view. Thanks

 

[John Spencer]

The VBA to open the form in Datasheet view is as follows

DoCmd.OpenForm "MySpecialForm",acFormDs

Look up the open form command in the VBA help.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[homezone]

Thanks so much for your help. It worked.