Enter Parameter Value error when opening form

N

newbietoo

Hi,
why do I get an "Enter Parameter Value" dialog box for LastName when I open
my new form? What would cause this?
Thanks,
Lynn
 
M

missinglinq via AccessMonster.com

You've posed a rather large question here with very little info to go on. The
dialog box popping up asking for a parameter would indicate that your form is
based on a query that is missinging needed data, i.e. the Last Name. This is
where I'd start looking. How did you develope the form, in Design View or
with the Forms Wizard?
 
M

Marshall Barton

newbietoo said:
why do I get an "Enter Parameter Value" dialog box for LastName when I open
my new form? What would cause this?
Click to expand...


There is a reference to LastName in the form's record source
query and the query's tables do not have a field with that
name.
 
N

newbietoo

hmmm... I'm almost certain the main form was created in Design View. You're
right, the form is based on a query. The last name field is in tblClient.
The main form is based on tblNom. I made a copy of the database and changed
the Record Source to a tblNom to see if the error would go away - no such
luck!
 
N

newbietoo

Marsh,
you guys are simply amazing. I found the problem buried in a subform/combo
box within the main form.
Thanks!
 
Top