then your combo has the ID as the bound column.
if you want it to save another column, then set THAT as the bound col.
You have probably used a look up field in your table - they are bad if you aren't aware of what they are doing - read and digest access.mvps.org/access/lookupfields.htm
Cross posted - https://stackoverflow.com/questions/...g-values-as-id
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓