Using data stored in a combo box

A

Andrea Stimson

Hello,

I'm in the process of setting up a report in access and one of the field in
the report needs to show data stored in a combo box in a form. I need to know
how to include the data from the combo box in a report. The combo box is
populated when a site id is entered in the form, the data in the combo box in
the site name which is taken from a drop down list.

I hope you can help me with this.

Regards
Andrea Stimson
 
A

Al Campagna

Andrea,
If I understand correctly...
Given that the form is open when the report is run, and assuming the
combo is on the main form, you can refer to the value in your combo box with
an unbound text control on the report. In the control's ControlSource...
=Forms!frmYourFormName!cboYourComboName
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
J

John W. Vinson

Hello,

I'm in the process of setting up a report in access and one of the field in
the report needs to show data stored in a combo box in a form.

The data is NOT "stored in a combo box". A combo box is just a display and
selection tool, not a data storage medium.
I need to know
how to include the data from the combo box in a report. The combo box is
populated when a site id is entered in the form, the data in the combo box in
the site name which is taken from a drop down list.

Base the report on a Query joining your table to the site-names table, joining
by the site ID, and include the site name from the table.
 

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

Top