Enter Value Parameter dialog box displays upon form exit -- it shouldn't.
Posted on 2003-10-23
I am using Access 2002
I have a form with with a combo box that has the following for the row source:
SELECT pid.pidname, pid.pidmonthyy, pim.pimcat, pid.pidtype, pid.pidid FROM pid INNER JOIN pim ON pid.pimid = pim.pimid WHERE (((pim.pimcat)=[forms]![pid].[picname]) AND ((pid.pidmonthyy)=[forms]![pid].[picdm])) ORDER BY pid.pidname, pid.pidtype, pid.pidmonthyy;
The logic works find while using the form. The above select statement is using two values from two combo boxes on the this form to narrow do the selection list in this combo box.
The problem is when you exit the form. A Enter Value Parameter forms!pid.picname dialog form appears and it shouldn't.
What can I do to correct this?