Datasheet view doesn't work when hiding access window 1

[Jables]

I am using the very helpful macro discussed in the FAQ,

http://www.tek-tips.com/faqs.cfm?spid=705&sfid=2562,

which shows how to hide the Access window.

One problem. I have forms that have their

DefaultView

and

ViewsAllowed

properties set to Datasheet. They have their

PopUp

properties set to True as per the FAQ. But when I open them, they don't display in the datasheet view, but only as continuous forms.

I am opening the forms from a command button. Here's what's in the command button's Click event:

DoCmd.OpenForm "frm1", acNormal

What is really strange is that if I open "frm1" by simply double-clicking it in the database window, then the Access window hides itself and the form displays properly in datasheet view.

 

[mp9]

To open a form in datasheet view, try:

DoCmd.OpenForm "frm1", acFormDS

http://www22.brinkster.com/accessory/

 

[Jables]

Of course it would be something that simple. Thank you for your help.