Subform refuses to come up as datasheet view

I have a button that activates a subform but whenever the subform pops up it’s never in datasheet view although in its property sheet I specified the default view & views allowed property to be datasheet, why?

I think I just replied to this at Woody's Lounge. Just in case you don't see it there ... here it is again.

Is there a chance that you are over-riding the settings on the form by using the acNormal argument in the code that is opening the form?

You may be using something like this:

DoCmd.OpenForm "YourFormName", acNormal ...... ect

In the example above the "acNormal" will force the form to open as a "Normal form". You can either remove the "acNormal" from the line or change it to "acFormDS" to force the form to open in Data Sheet view.

HTH
RDH

thanks! it worked