Form opens as pop-up window even if form set to pop-up=No

[Chummly66]

Hey guys,

Got a stumper and can't figure it out.

I have a search form that allows me to find a record, and then double click on it to open the form with that record. The actual code is:

DoCmd.OpenForm "Workorders by Customer", , , " customers.customerID = " & Me.lstCustInfo, , acDialog

The problem is, that it always opens the "Workorders by Customer" form as a pop-up window even though the properties of the form has Pop-up = No, and Modal = No.

The form also acts Modal, in that if you open another form from this "pop-up form", the other forms always opens in the background and you cannot access it.

Any thoughts or advice would be appreciated!!

Richard

 

[mp9]

Take the acDialog off the end of your command. This has the effect of over-riding form properties and forcing it to open as a pop-up, so take it off and your form's pop-up and modal properties will be applied properly.

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

 

[Chummly66]

Thanks MP9.. that did it... much appreciated!!