Show form or Table as Datasheet

  • Thread starter Thread starter Carl Mankat
  • Start date Start date
C

Carl Mankat

I seem to be missing something. I want to have a command button on a
form that opens up a form in data sheet view. No matter what I attempt,
using Form Operations I get a single record at a time. I could with to
data sheet view but that's crude.

What am I missing?

TIA

Carl
 
In the OnClick code against the command button change the DoCmd line to use
acFormDS. See example below

DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria
 
Back
Top