General information
Category:
Forms & Form designer
Title:
Combo box returning wrong values
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only