* in a number field

[cochise]

I have numerous queries that refer to a combo box on a switchboard form for the criteria value for the query. On my queries in the criteria field under a EmpNum field (number/integer) I have the following text:

Like [Forms]![Switchboard]![Report Form].Form.cmbEmpNum

I would like the query to sort using "*" for all employees, however, it won't allow me to set the combo box to "*". I'm assuming that's b/c I'm using a number/integer data type. Does anyone know how I can go about this?

 

[cochise]

Okay, I figured it out. If curious, I created a non-visible text box which either had a value of my combo box or a "*" and changed my query criteria to reference the new text box.