#name? error on textbox with datasource from joined table

[EONTECH]

I have a form based on a view. The view has three tables--the data table and two lookup tables (Doctors, MedicalGroups, and StatusCodes). THe Doctors table has a groupID and StatusID field (as well as all its regular data fields). I want to have a textbox on the form that displays the Group Name and the Status Description, as opposed to the IDs of each of these. IN design view, I placed the textbox, set its datasource to the fieldname from the view. When I run the form, i get the #Name? indicator in the textbox. Any ideas?

Thanks,

 

[EONTECH]

I figured it out. I didn't create this--another developer did. I discovered that he had a bad habit of embedding SQL queries in several places throughout his code, especially in the various Form events. I had to modify four different instances of the SQL query. I am surprised that I didn't pick up on this when I debugged the form.