Combo box selection go to a Report

J

Jp3007

I have a combo box created in a form. On selection form the combo box, "on
click " the selection, I want it to take that selection and drop it to the
report.
 
K

KARL DEWEY

If you are using the ComboBox as a criteria in a query then also add it as an
output field in that query.
 
J

Jp3007

I guess I'm lost. It seems like it should be so simple. I can get the
information to drop into a form, but I need it to go to a report. I can get
it to go to the report I want, but it goes to the first record instead of the
selected record.
 
K

KARL DEWEY

Where did you put the ComboBox?
In a form? How are you using it?

In a report? How are you using it?
 
J

Jp3007

Currently I have it in a form. The combo drops a list of test names. I want
to be able to select the test name and have a report with the test name and
all the fields associated with that test. I'll try to create a combo in a
report and see if that work. Didn't know we could do that.
 
K

KARL DEWEY

Back to my earlier -- Use a query as record source for your report. Use the
ComboBox as a criteria in a query then also add it as an output field in that
query.
Open the report in design view and add the field.
 
Top