Drop Down List writes wrong data to table

[Paul_birm]

Hi.

I have a series of 3 drop down boxes on a form. each drop down has text data in such as tom, dick, harry etc.

when you select, say 'tom' - the data table, when viewed after, is holding the value of the item on the list - ie 1 in the case of 'tom' or 2 inthe case of 'dick' - INSTEAD i NEED the data file to hold the ACTUAL data chosen, NOT the value of it on the drop down list.

what am i doing wrong here and how can i fix it. thanks in advance

 

[DCrake]

Have you got table level lookups? is for remove them. If not make sure the bound column is the correct one set on your form combos.

Do Not Double Post

 

[Paul_birm]

DCDrake

sorry, not sure what you are asking me to look at

1) properties - for the Drop down boxes ???

or

2) properties - for the data table holding the data that the combo boxes look at

can you explain further please