how to reference combobox's column property from textbox on a report

[freeskier]

hello,
i have a form that opens for a report. the user selects criteria from combo boxes, clicks ok, the form is hidden, and that criteria is applied to the recordset of a report that opens. i would like the value of one of the combobox to appear in the report title.

i have been trying in a text box:
=[Forms]![frmCriteria]![cboCombo]
and this works fine. however, i would like the value of the second column and trying this has not worked so far:
=[Forms]![frmCriteria]![cboCombo].[Column(1)]

what is the proper syntax?

thanks

[Rabbit]

Get rid of those brackets.

[ADezii]

hello,
i have a form that opens for a report. the user selects criteria from combo boxes, clicks ok, the form is hidden, and that criteria is applied to the recordset of a report that opens. i would like the value of one of the combobox to appear in the report title.

i have been trying in a text box:
=[Forms]![frmCriteria]![cboCombo]
and this works fine. however, i would like the value of the second column and trying this has not worked so far:
=[Forms]![frmCriteria]![cboCombo].[Column(1)]

what is the proper syntax?

thanks

Good news, you can actually keep 6 of the 8 brackets, just lose 7 and 8:

=[Forms]![frmCriteria]![cboCombo].Column(1)

[freeskier]

when i enter that into the textbox it is automatically changed to read

=[Forms]![frmCriteria]![cboCombo].[Column](1)

Good news, you can actually keep 6 of the 8 brackets, just lose 7 and 8:

=[Forms]![frmCriteria]![cboCombo].Column(1)

[ADezii]

when i enter that into the textbox it is automatically changed to read

=[Forms]![frmCriteria]![cboCombo].[Column](1)

When frmCriteria is Open, it will automatically be formatted to:

=Forms!frmCriteria!cboCombo.Column(1)

[freeskier]

When frmCriteria is Open, it will automatically be formatted to:

=Forms!frmCriteria!cboCombo.Column(1)

thanks so much! yet another MS Access idiosyncrasy...

[Rabbit]

thanks so much! yet another MS Access idiosyncrasy...

Well.. it's not too odd an event. When a form is not open, the controls are not loaded so if you try to reference it, Access won't know what it is, hence the brackets. But if the form is loaded, then Access knows what you are trying to refer to.

[Ham1zan]

Hello, i know that this thread has been solved, but i have a similar issue with freeskier.

I would like to know, would the solution

=[Forms]![frmCriteria]![cboCombo].Column(1)

work if i were to add it in the Criteria row of a query?