Enter Parameter Value message when opening a form

[jbeets]

Hello,
In my database I have many forms that are set up the exact same way with the exception of what table the data is being pulled in from. Yesterday everything was working properly but this morning when I went to open the forms I am getting a pop-up box "Enter Parameter Value" and then "Forms!frmPropertyAudits!cboEmployee" - each form I open gives the same message but refers to the correct form in the description. There is one form that is not giving this error message and opens properly.


Forms Record Source is: SELECT tblPropertyAudits.* FROM tblPropertyAudits WHERE (((tblPropertyAudits.UserName)=[Forms]![frmPropertyAudits]![cboEmployee]));

If I remove the WHERE portion of the statement, save and then put it back in, close and reopen the form everything works perfectly again. But then I close the database and reopen and we are back to the error message.



Does anyone know why this is happening and what I need to do to fix it?

Thank you in advance for any help you can provide!

[ranman256]

the form:

[Forms]![frmPropertyAudits] MUST be open for the query to work.
is the form actually open when the query runs?

[jbeets]

No it gives me that error when I try to open the form

[Gicu]

Can you upload a small sample of your db with just a couple dummy records so we could see it? You are not very clear in your explanation, in one point you say

with the exception of what table the data is being pulled in from

then

Forms Record Source is: SELECT tblPropertyAudits.* FROM tblPropertyAudits WHERE (((tblPropertyAudits.UserName)=[Forms]![frmPropertyAudits]![cboEmployee]));

. Are all the forms based on the tblPropertyAudits (and if yes why do you need multiple identical forms)? Do you manipulate the record source in VBA for any of the forms?

Cheers,

[Bullschmidt]

Or I wonder if cboEmployee could have been accidentally renamed.