tables displaying wrong info

[brh01]

Hi, When I go into my tables of saved data from a form, I've noticed some of the columns w/ stored values have in them the data I typed on the form, and some (which correspond w/ the forms combo boxes) are storing row numbers from my table, not the selection itself.

My problem is, when filtering thru a combo box on a form the list that drops down only displays the row numbers, not the info I need to choose from. can I fix this?

Brian

 

[hkaing79]

Hi Brian-

Is the form bound to a table? How are you storing your selection into the table?

What is the rowsource property of your combobox? If you have multiple columns, you'll need to change the Column property.