>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?

Set the Combo's BoundTo property to .T.