Report reference combo box text

[Robin9876]

In an Access 2000 report how can you reference the text value of a
combo box on an opened form?

 

[Maurice]

You could place the reference in your query if your recordsource of the
report is a query. It could look like this [Forms]![formname]![Comboname]

Where formname is the name of the form you're referencing to and the
comboname the combo on your form.

Maurice

 

[Robin9876]

I should have mentioned this is for in a label in a report to display
the text from the form combo box.

You could place the reference in your query if your recordsource of the
report is a query. It could look like this [Forms]![formname]![Comboname]

Where formname is the name of the form you're referencing to and the
comboname the combo on your form.

Maurice

In an Access 2000 report how can you reference the text value of a
combo box on an opened form?

 

[Robin9876]

I have been able to get it to work by using [Forms]![formname]!
[Comboname].Column(1)

I should have mentioned this is for in a label in areportto display
thetextfrom the formcombobox.

You could place the reference in your query if your recordsource of the
reportis a query. It could look like this [Forms]![formname]![Comboname]

Where formname is the name of the form you're referencing to and the
comboname thecomboon your form.