Opening a Form in Datasheet View

[Paul H]

*Sorry if this is a double post. I received an error on the first try.*



I am opening a form in datasheet view from another form, but it opens up in Continuous Form view. When I open the form manually it opens up properly. I don't see any arguments in the Open Form command to set the view. Here's my code.

DoCmd.OpenForm "frmAllChecks"

What am I missing?

[Paul H]

Never mind. I kept hacking at it and now it works. Don't know why. One of those Access things, I guess.

[pbaldy]

I don't see any arguments in the Open Form command to set the view.

Presumably you noticed the View argument, of which one option is acFormDS?

[Paul H]

I did see that, but didn't recognize "acFormDS" which is a little cryptic, I think.

Thanks for the tip.

[Missinglinq]

'Cryptic' is Access' middle name! Seriously, you always have to be careful when opening a Form using

DoCmd.OpenForm

Things frequently are not what they seem!

Linq ;0)>