query criteria

[SoggyCashew]

Hello and happy Thanksgiving! I have a Field named UserID and its criteria
comes from a combo box on a form named frmCalendar. I want to use this
formula in the criteria but it wont let me. What does it need to work? Thanks!

Forms!frmCalendar!cboUser.column(5)

 

[Rick Brandt]

Hello and happy Thanksgiving! I have a Field named UserID and its
criteria comes from a combo box on a form named frmCalendar. I want to
use this formula in the criteria but it wont let me. What does it need
to work? Thanks!

Forms!frmCalendar!cboUser.column(5)

Two options: Place a hidden TextBox on frmCalendar with a ControlSource
of...

=cboUser.column(5)

....and then refer to the TextBox in your query.

You can also try wrapping your existing expression in the query with
Eval(). I have never tested that, but I have read that it works.

EVal(Forms!frmCalendar!cboUser.column(5))

 

[SoggyCashew]

Thank You! I was just reading about the eval but in the expression they used
quotaions. Thank you for your help and hapy holidays!

Eval("[Forms]![frmCalendar]![cboUser].column(5)")