I have a combo box that for some reason stores p_key+1 to the table. It displays the correct value, (p_key-1) on screen, but any queries based on a view shows the next highest record.

Essentialy, it is a rowsourcetype = 6, fields
rowsource = rank_tbl.rank_name,rank_key
bound colum = 2
controlsource = perstbl.rank_key
Selecting CPL (rank_key = 26) from the drop down stores 27 to perstbl.rank_key.As 27 is a private, the corporal is understably t'd off.
Going back to a record displays the correct value, i.e CPL, but a report shows PTE (Private).
This happens for all records, and it gets realy confusing with civilians, MR becomes MS., MISS becomes MRS, MCPL becomes LS, etc.
What the ^&*% is going on?