Show form or Table as Datasheet

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
 
G

G. Vaught

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

DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria
 
Top