Combo box displays wrong information in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
?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/
 
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?
 
Back
Top