Forcing Datasheet View

[SteveF]

I need to open a from in datasheet format to enable me to tab through columns of figures. I can do this easily enough, but when I use a command button from another form that I am using as a menu it opens in a single form format that I really don't want.

Any ideas? As usual, all help appreciated.

 

[missinglinq]

Another one of Access' quirks!

DoCmd.OpenForm "YourFormName", acFormDS

 

[SteveF]

Another one of Access' quirks!

DoCmd.OpenForm "YourFormName", acFormDS

More genius, I love this forum, thanks a million!

 

[ajetrumpet]

More genius, I love this forum, thanks a million!

Wow Linq. You're really a genius. Good work! j/k/

 

[missinglinq]

In the Kingdom of the Blind the One-Eyed Man...

 

[SteveF]

I just used this again, 2 years on from the original post. Great forum...