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?