problem with DoCmd.OpenForm

[BlackBearDude]

I have two small forms that I allow the user to open from a main form. I want them to be modal, so I use the acDialog value in the call. Upon return, the main form is updated - possibly reflecting a change made in the called form. This works perfectly as long as the called forms are singleform instead of datasheet. When I change the call to force the openform to be datasheet (using acFormDS), the modal aspect is ignored.

Anyone know why this occurs and how it can be corrected?

 

[nealvenables]

Hi,

I'm pretty sure a datasheet form is actually a table/query (and vice-versa) so this may never work as you anticipate.

You could try making your datasheet form a sub-form of a new parent form and have your code open the parent instead?

 

[BlackBearDude]

nealv,

That sounds like a great way to solve it. I'll let you know if that works, it certainly should!

It sure would be nice if MS documentation was clear on issues such as this. In other words, why no message indicating that one parameter was in conflict with another (acFormDS vs acDialog).

Thanks