Form is Datasheet but opens single record mode?

[Bob]

I have a slew of forms that I created with the Form Wizard - all are
datasheet mode. If I open them direct from the Database Window, they
open as datasheets. But, when I use a button on another form to open
them (created from the toolbox command button tool) they open in
"single record" mode. I've checked several times and they are fine
when opened directly, it's just then they are opened from the button
that they don't work.

How can I get them to open as datasheets ?

Thanks,

 

[Douglas J Steele]

By default, DoCmd.OpenForm always opens forms in Single Record mode.

Rather than

DoCmd.OpenForm "MyForm"

use

DoCmd.OpenForm "MyForm", acFormDS

 

[Bob]

use

DoCmd.OpenForm "MyForm", acFormDS

thanks, that did it