Passing combo box value to report

[wgma]

I am creating a report that gets some of its data from a form. One of the items that I need from the form is the text contained in a combo box. All I need is the text that is displayed in the combo box.

I have tried some different things but just get errors. I have searched this forum but have not found any help.

I am sure that this is very simple but can someone tell me how to pass/retrieve the text from a combo box?

Thanks.

 

[Rich]

An unbound textbox with the control source set to=Forms!YourFormName!Its comboName keep the form open while the Report is loading

 

[wgma]

Thanks for responding. I have it set to that but I am getting is the record ID. I need the text that is displayed in the combo box.

 

[midmented]

You must have more than 1 column in your combo box.

Try using:
Forms!YourForm!ComboBox.Column(1)
(Whatever column the data is in 0, 1, 2, etc.)

 

[wgma]

Perfect! thanks.

 

[midmented]

You're welcome

If someone has helped you, please add to their reputation
by clicking on the icon above that looks like the scales.

Thanks

 

[wgma]

Sorry, I did not know abut that.