Value from compbo box on report

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

Guest

I have a report that pulls most of it's data from forms. I have 3 combo
boxes on a form where users select an item. When I go to create the report,
the report pulls the ID number from each combo box instead of the text value
the user selected. How can I change it so the report shows the text value
instead of the ID number. Please Help!

Thanks!
 
Look at the rowsource of each combobox and note what column the text value
you want is in. On your report use this syntax:
Forms!nameOfForm!NameOfCombobox.Column(X)

The column property is zero based so if you noted the text value is in
column 2, X = 1.
 
jped said:
I have a report that pulls most of it's data from forms. I have 3 combo
boxes on a form where users select an item. When I go to create the report,
the report pulls the ID number from each combo box instead of the text value
the user selected. How can I change it so the report shows the text value
instead of the ID number.
Click to expand...


Try using the Column property.

It would perhaps be better to Join the lookup tables to the
report's main table in its record source query.
 
Thank you very much! That worked!

PC Datasheet said:
Look at the rowsource of each combobox and note what column the text value
you want is in. On your report use this syntax:
Forms!nameOfForm!NameOfCombobox.Column(X)

The column property is zero based so if you noted the text value is in
column 2, X = 1.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Click to expand...
 
I have been working on this same issue except that I am using a select table
query as my record source instead of a form. (I don't know how to make a
report from a form). I tried this syntax below in the control on my report,
but it didn't work. I am trying to figure out how to display the text, not
the ID, from the lookup table on my report. Any suggestions?
 
Back
Top