Using a button to display datasheets

B

Bill

I setup a form that has a button on it that runs a form. How can I get that
button to run the form, but display the results as a datasheet? If I click
on the form directly, it shows the datasheet. Using a button on another form
does not.
 
J

John Spencer

Your button probably is using VBA to open the form. You need to edit the line
to open the form in datasheet mode.

DoCmd.Openform "YourFormName",acFormDS

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Datasheet Total Row 3
Crating User Form to Add Names 1
Program buttons to create a word document 0
Using Buttons to display datasheets 3
How do I clear a form? 0
Datasheet combo box empty 1
Reports Recordsource from subform datasheet (filtered) 0
Open form as Datasheet 3

Top