Using a button to display datasheets

  • Thread starter Thread starter Bill
  • Start date Start date
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.
 
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
 
Back
Top