parameter qry with a twist

[Junior]

parameter query based on selections in unbound cbo boxes to print a report
the cbo that i need help with has possible selections 'TYP'=typing,
'STEN'=steno, or 'All'= Not Required (when all is selected , i want to find
all records to

in the query a field named RegID holds the parameter [forms!frmOne.cboReg]
Records may have TYP or STEN or may be null
the query works ok when the query RegID and cboReg match -
But i also want to find ALL records if All is selected in the cbo
i know i need to modify the query but i'm stumped - help please

 

[John Spencer]

One method:

Field: RegID
Criteria: [forms]![frmOne]![cboReg] OR [forms]![frmOne]![cboReg] ="All"

Another method - assuming the RegID ALWAYS has a value is to change your
combobox to two columns and hide the first column. Column one would have
the values *, TYP, and STEN; column two would have ALL, Typing, and Steno

Your criteria would be
Criteria: LIKE [forms]![frmOne]![cboReg]