using option group to change multiple field query criteria

[Guest]

Hi all, new to group; thanks in advance for any guidance.

I would like to use several option groups on a form to set Query Criteria
for different Fields on the Form. This works OK by pointing to the Form's
Option Group Control in the Query Criteria line. But Option Control Values
are limited to numbers (I would like to use expressions to set criteria).
Also, I don't know how to 'turn off' the Criteria when I want to just show
all records on the Form.

Is is possible to set query criteria using a macro? Or should I use some
other means?

 

[[MVP] S.Clark]

You'll have to do something in code that resets the value to null for the
user. Maybe a button to clear all criteria??

In the future, use a combobox instead.