Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 97 Datasheet Form problem 1

Status
Not open for further replies.

jaegca

Instructor
Dec 5, 2001
20
US
I am working in Access 97 - created a form from a query using the Wizard and selected "datasheet" from the view options - put a command button on another form to open the datasheet form. The form opened in single form view so I set the properties of the form to Default View "datasheet" and Views Allowed "datasheet". When I used the command button to open the form, it keeps opening in Single Form view! Any suggestions or help is greatly appreciated - Cindy
 
Add the acFormDS parameter to your button. That should do it.

DoCmd.OpenForm "[form_name]", acFormDS
 
Worked like a charm - thank you so much!!!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top