Update Query returning a letter rather than number

[Ant_Snell]

I an trying to build an update query that updates a table with a value in an open form (the ID of the record). Couldn’t get it to work so to test it is pulling the correct value I created a new field in a select query using the same syntax.


test: [Forms]![frm_Index_Enquiry]![frm_Enquiry].[Form]![EID]
it is returning a single letter e.g. u, v, w etc. but the EID field is actually number. Any ideas why and how to correct this please?

[Minty]

Is the EID a lookup field in the source table?
They can often obfuscate the stored value.

What is the control source for the EID control, has something been renamed somewhere.
I always change textbox control names to txtFieldName so I know that I am referring to the control and not the underlying field value.

[Ant_Snell]

The form is based directly to the table (no interim queries) and the field is the key ID field an Auto Number type. I also tried placing an unbound field on the form and making it equal the EID then ensuring the format was number but got the same results. Something is happening because each time I run the query and the ID increments by 1 the letter changes

[Minty]

Without seeing the table and a simple form demonstrating the issue, I'm afraid I have no other ideas?
Can you upload a demo of the problem?

[Ant_Snell]

I will see if I can recreate a small example then post. thanks