Dialog Pop-Up When Opening Navigation Form but Not When Form Opens Individually

[elhale]

I have built a navigation form (uses the horizontal tabs) for 5 existing forms in my db. One of the forms pops-up a dialog box for data input when it is opened/loaded in the navigation form. This form does not do this when opened individually outside of the nav form. The dialog is for one of the fields (a combo box) I have on the form, and the only event I have attached to it is an "after update" macro that performs a "requery" to modify the items that display in another combo box on the same form. Not sure why this field pops-up a dialog asking for data input when loaded in the navigation form, yet not when opened on it's own. Any help would be greatly appreciated.

I did read/search/scan the forums to see if this was addressed, but couldn't find anything. Apologies if it's posted elsewhere.

[pbaldy]

Typically when this happens there's a reference to the form, probably in the criteria, and the syntax changes when it's a subform:

http://access.mvps.org/access/forms/frm0031.htm

You can use the Build function to create the proper syntax as well.

[elhale]

Thank you Paul, I'm continuing to work on it from that angle. Still haven't found the solution, but I'll keep working on it.

[pbaldy]

No problem. You can attach the db here if you still can't find it.