T
Terri
Hi,
I have a query where the criteria line is pulling from a form that I have
built. The user can either use the combo box to select the value he/she
wants or can use the check box to "select all". Where I am running into some
problems are when I use the check box.
I understand that the basic concept the check box only represents:
True / 0 /Yes
False / -1 / No
How can I get the values set for the check box to represent all values in my
combo box and make it work in query? (So, that my query picks up all values.)
I am guessing that there are multiple ways to get this to work such as:
SetValue control in a Macro
Write a query and maybe link it up to my check box properties
Can someone help me - please be specific, not using SQL. (I don't know how
to write in sql.)
Thank you!
I have a query where the criteria line is pulling from a form that I have
built. The user can either use the combo box to select the value he/she
wants or can use the check box to "select all". Where I am running into some
problems are when I use the check box.
I understand that the basic concept the check box only represents:
True / 0 /Yes
False / -1 / No
How can I get the values set for the check box to represent all values in my
combo box and make it work in query? (So, that my query picks up all values.)
I am guessing that there are multiple ways to get this to work such as:
SetValue control in a Macro
Write a query and maybe link it up to my check box properties
Can someone help me - please be specific, not using SQL. (I don't know how
to write in sql.)
Thank you!