Using combo box Column property in a query

[aziz rasul]

I want to use the value in the second column of a combo box on a form for the criteria in a query. What syntax do I use? I have tried:-

[Forms]![frmChallenges]!cboProvider.Column(1)
Like [Forms]![frmChallenges]!cboProvider.Column(1)

but it doesn't like it.

 

[wazz]

you could try:

Public Function GetComboValue() As String
    GetComboValue = [Forms]![frmChallenges]!cboProvider.Column(1)
End Function

then put this as your criteria (with parentheses):
GetComboValue()

 

[boblarson]

You can't use columns in a query. It doesn't work. You can set a text box to be the value of the combo column and then reference that text box in the query.

 

[aziz rasul]

Thanks both. Tried the text box route which of course worked.