Enter Parameter Value error when opening form

[Guest]

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

 

[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?

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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Marshall Barton]

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

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.

 

[Guest]

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!

 

[Guest]

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