All,
On my form is an unbound Check Box control which obviously would represent a "True" or "False" value.
If the box is checked ("True"), then I want to search for a specific value in a query (which runs upon clicking a button on that same form) - but it's NOT a boolean field.
The data type is "Short Text", and contains the value "A" or "V".
Is there a way to do the following
If box is checked on the form, pull over values in which that field is equal to "A" or "V"
If box is NOT checked on the form, only pull over values in which that field is equal to "A".
EDIT:
I think I've figured out what to do - the info in the below article has helped
https://stackoverflow.com/questions/...ria-in-a-query