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

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
No text box in word 2016 0
Combo box 0
Combo or list box 0
Link a text box based on drop down box with four options MS Word 365 0
Report, Combo Box 1

Top