NAME#

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

I have an edit form that needs to pull data from 2 tables. I pull in all the
data from the 1st but when needing the last name to be attached the column
reads NAME#. Does this have something to do with the way the table are linked?
 
I have an edit form that needs to pull data from 2 tables. I pull in all the
data from the 1st but when needing the last name to be attached the column
reads NAME#. Does this have something to do with the way the table are linked?
Click to expand...

The NAME# means that you have a Control Source or a query field which
references a table field that Access doesn't recognize. It might be misspelled
(e.g. [Last Name] instead of [LastName] or [Last_Name], or it might be a field
that wasn't included in the form's recordsource, or...

We cannot see your database so there's no way to be sure. Perhaps you could
post the SQL view of the form's Recordsource query (or the main and subforms'
recordsources if you have a subform, which would be prudent); and the Control
Source of the control which says #NAME.
 
Back
Top