#Name? appears in a form, but not in the underlying query

  • Thread starter Thread starter Paul James
  • Start date Start date
P

Paul James

I've got a form that uses a query made up of two related tables. When I
view the query itself in datasheet view, all fields display properly, with
no #Name? values. But when I view these same query fields in my form, one
of the fields displays #Name? for all records.

What causes this to happen?

Thanks in advance.

Paul
 
I should also add that this field is bound to a text box control on the
form, and I added the text box to the form by dragging the field from the
Field List box. So I know I didn't misspell the field name, or try to add a
field that isn't in the underlying query.
 
Is there any other object on your form that has the same name as this field?

Is there any built-in property/method that has the same name as this field?

If you have not done so previously, turn off the Name AutoCorrect boxes
under Tools | Options | NameAutoCorrect, and then compact the database.
 
Back
Top