creating a form

H

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
 
E

Ed Robichaud

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

homezone

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

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
'====================================================
 
Top