R
Robin9876
In an Access 2000 report how can you reference the text value of a
combo box on an opened form?
combo box on an opened form?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
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
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
R
Robin9876
I should have mentioned this is for in a label in a report to display
the text from the form combo box.
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
Robin9876 said:In an Access 2000 report how can you reference the text value of a
combo box on an opened form?
R
Robin9876
I have been able to get it to work by using [Forms]![formname]!
[Comboname].Column(1)
[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.