Report, Combo-Box

B

bandjknutson

When attempting to create a report from a query, one of my record sources is
a combo box. When the report is generated, the field that should be populated
by the combo box text entry is filled by the primary key of the table used to
fill the combo-box.

How can I have this show the text instead?
 
A

Allen Browne

Open the report in design view.
Look at the RecordSource property of the report.

Change this to a query that includes both the table(s) you need to get your
data from, and also the table that supplies the values for the combo (i.e.
its RowSource.) You can now add the combo's lookup field to the query
output, and the field will be there to display on the report.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report, Combo Box 1
Using data stored in a combo box 2
Display Combo box result in Report 1
combo boxes and their output to reports 1
Append query and combo box on the form 1
Combo box size in report 2
Combo Boxes 1
Combo Box and First Record 5

Top