modal property not working

[rivereridanus]

I have a button on a form that opens a form called itemqueryform2 with this code:


Private Sub lookupitemsbutton_Click()
DoCmd.OpenForm "itemqueryform2", , , , , acDialog
I want it to open in a Dialog window, with the modal property set to No so that my user can switch easily between the dialog and the form she is using underneath.

In the properties panel, I selected Popup YES and Modal NO, but my form still does not allow users to click out of it without closing the form.

Any suggestions?

[pbaldy]

Generally speaking an argument specified in OpenForm will override the form's settings (like the edit settings). I suspect that's happening with acDialog, so try dropping that.

[rivereridanus]

That fixed it. Thank you!!

[pbaldy]

Happy to help!