Report Data Problem

[sherry1]

I have a report that is based on a query of 4 tables. One of the tables are based on information that is selected in a form. On the form there are combo boxes that list several possible entries the user chooses from. The form works fine and you can choose the correct items. When I go to the table where the data is stored, it is storing only the ID number of the item rather than the actual text. This wouldn't matter much, except that when I pull a report from the tables, it fills in the ID number rather than the actual Text entry. How can I fix this? I'm not sure why it is storing the ID number in the first place.

Sherry1

 

[katiekat]

Where is the information coming from for the combobox? How are the id numbers linked to the text for the item? On your report, what field do you have showing that info? The combobox or the feild from the table where the data is stored?

Yeah, lots of questions! Holy tek-tips batman!:-0

 

[Vika]

Most likely your problem is in the Combo box data settings. What you need to do in this case is go in to the properties of the combo box. Go into the Data Tab, and change Bound Column property. This property sets which column from the combo box to save if you have more than one column shown.

Hope it helps!

 

[sherry1]

Thanks Vika & katiekat!

Vika your solution worked perfectly!

Sherry