Passing value from a form Combobox to a Report 1

[Sloaner]

I have a form with a button that calls a report.The form prompts for companyName and for ordertype(2 comboboxes).I would like to know how to pass the value of the ordertype combobox to my report. The report controlsource is a query. In that query I have the ordertype as

Label_ContainerType: [LabelTypeName] & " " & [ContainerTypeName]

In my report is a textbox field whose recordsource I made same as above in order to print the data being passed.

Label_ContainerType: [LabelTypeName] & " " & [ContainerTypeName]

unfortunately the report prints out the field blank.

Any suggestions on how to handle this problem anyone???

Thanks in advance.

 

[Sloaner]

Actually the field in my report has the following as controlsource

=([LabelTypeName] & " " & [ContainerTypeName])

 

[scriverb]

Just identify the control source property as the name: Label_ContainerType. You see if the name you need is in your RecordSource and has a named alias then just refer to that name. No need to refer back to the ComboBox in the form.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[Sloaner]

Thanks ... it works like a charmb.