Pass Combo Box values to report

[Guest]

I have a form that passes criteria to a report.
A combo box selects from a table with two fields code, description.
Two questions
1. On selecting a code it would be nice to print the description for the
code selected alongside the combo box in the form.
2. I can pass the code to the report, how can I pass on the description as
well.

Thanks
CJ

 

[Allen Browne]

Create a query using your exising table and also the combo's RowSource
table. This way you can add description field to the query grid.

Then open your report in design view, and set its Record Source property to
the name of the query. Since the description field is in the query, you can
now use it in the report.

 

[Guest]

Understand the principle thank you

How do I add the combo's row source to the new query?

Thanks

 

[Allen Browne]

1. Click the Query tab of the database window.
2. Click New.
3. Choose Design View.
4. In the Add table dialog, add both tables (i.e. the one that you want to
use, and also the one that contains the 2 fields for the combo.)