how do refer to used bound cbo value in a query?

[Insomnia]

Hi guys, I guess this should be the easiest thing ever, but I just can't get it work, I have tried the following syntaxes:

[Forms]![Form1]![cbo1].[BoundColumn]

[Forms]![Form1]![cbo1]

[Forms]![Form1]![cbo1].[Text]

[Forms]![Form1]![cbo1].[Value]

the "value" is a text and I use it in a where clause

 

[maxmangion]

the general syntax is:

[Forms]![Formname]![ControlName]

 

[Insomnia]

Just As I thought, can't see why it won't work though. but nema problema, I use a txt field instead, works just fine!

 

[maxmangion]

what was your column count in your combo box ? that might was your problem.

 

[Insomnia]

the combo has 3 columns, the txt was the second, I have now changed it to be the first (column(0)) , but it still doesn't work.

it is not a big problem though, but very iritating not being able to solve it