Combo box displays wrong information in report

[Guest]

When I use a combo box in a report it displays the index number instead of
the value in the lookup table. How can I get the value to display instead of
the index number? Thanks.

 

[Jeff Boyce]

?A combo box in a report? Combo boxes work great in helping you look up
values in a form. But when you send data to a report, you have already
selected the data.

Could you explain more about why/how you are using a "lookup" in a report?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Hey thanks for the reply, I tried it two ways.
1) I setup in my table a field that uses a lookup table to pull the data from.
Then when I create my report I drag that field onto the report and it shows
up as a combo box. Instead of printing the selected value on the report it
prints a number (index number) that cooresponds to the selected value in the
lookup table.

2) I set the field to text in the table, then on the form I use a combo box
to lookup a value to place in that field. When I print the report I still
don't get the expected result. I'm not sure what the best way to do this is.
Maybe it is better to not create the table (field) using the lookup option? I
don't know?

 

[Jeff Boyce]

Use a query to join your table to the lookup table on the index field.
Select the "looked up" value, rather than the index value. Add any other
fields you want to see.

Base your report on that query.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/