Field on Form gives Error

[Guest]

I designed a form with record source a table containing among them the
numeric (long integer) field ContactID.

I added the field to the form using the field List (drag and drop).
The field gives me the value #Name? when shown in the form.
All other fields in the form are displayed correctly.
I checked and double checked if the name of the field is not misspelled but
as I used drag and drop from the field list, what can go wrong here?

When I invoke the Query Builder and look at ContactID, it is shown normally
and has normal values.

The form is used as a sub form but does not have Linked Child Fields
(doesn't need it in this case because the Parent Form has no Record Source).
When displayed without the Parent Form, but on it's own, the values of
ContactID are displayed correct, as a subform not.

 

[Guest]

I think that this typically means that there is something else on your form
with a similar name. I suggest that you look through the names of all
controls to check that you do not have another one called ContactID. Also I
typically like to change the name of the textboxes that hold the fields so
that name issues do not come up.