creating a form

  • Thread starter Thread starter homezone
  • Start date Start date
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
 
Open your form in design view, select "properties", then set the default and
allowable form styles.
 
I've tried that and everything else I can think of, but it is still opening
in form view. Thanks
 
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
'====================================================
 
Back
Top