If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using data stored in a combo box
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 -- Andrea Stimson Technical Administrator |
#2
|
|||
|
|||
Using data stored in a combo box
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." "Andrea Stimson" wrote in message ... 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 -- Andrea Stimson Technical Administrator |
#3
|
|||
|
|||
Using data stored in a combo box
On Wed, 29 Oct 2008 04:48:01 -0700, Andrea Stimson
wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|