using combo columns ina query

[Nialler]

Hi
I'm trying to run a query which gets it criteria from the second column in a combo box but I keep getting the error. "This expression is typed in correctly or is too complex to evaluate". In the combo box I have e.g Mar in column1 and */03/* in column2.This would then hopefully select all the March months. The code in the criteria is
[Forms]![frmReportDept]![2ComboMonth].[Column(1)]. Anyone have any idea what is wrong with it. I've tried a few variations on the above but nothing works
Thanks
Niall

 

[CosmoKramer]

Try:

[Forms]![frmReportDept]![2ComboMonth].Column(1)

 

[Nialler]

When I tried this -> I got Undefined function '[Forms]![frmReportDept]![2ComboMonth].Column' in expression

any other ideas. I really don't understand why it won't work
Thanks
Niall

 

[justa]

Make sure you specify the column number i.e. column(0) is the first column in your combo box, column(1) is the second column. Also, are you sure your combo box is set up with two columns?

 

[Nialler]

Yeah I have made it visible to makesure. Its the second column so I refernce it with column(1)