Subform refuses to come up as datasheet view

[arage]

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?

 

[R. Hicks]

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

 

[arage]

thanks! it worked