The perplexing #Name Error

[twcaddell]

I have a form that pulls all the data from a query. After the form was complete, my customer had a good idea that caused me to add two more fields from a different table. Using the query builder, tables added to the query and the correct fields added to the query. I can see the data when I view the query, but when I added the fields to the form, I get the "#Name" error displaying in the text box.

Any ideas would be greatly appreciated.

TC:banghead:

 

[pr2-eugin]

Make sure the Controls have their source bound properly to the fields.. It would be more easier to examine the RecordSource of the form once more.. Try adding all fields again..

 

[twcaddell]

Thanks Paul
Not sure why this happened, but I closed the form, reopened the form and the correct data displays as I traverse the record set.
Thanks
TC

 

[pr2-eugin]

Good you have it working.. Good luck !!