Hello.
I'm having some issues with my first attempt at query by form. I've got the form and the macro set up, but my query doesn't want to play nice. bascially, it will only return information if only 1 field has the qbf string.
[forms]![search_form]![employee_last_name] or [forms]![search_form]![employee_last_name] is null
that works awesome until you try to put in another string, like for employee first name. Any help would be great, as i have never done this before and am eager to get it working.
I'm having some issues with my first attempt at query by form. I've got the form and the macro set up, but my query doesn't want to play nice. bascially, it will only return information if only 1 field has the qbf string.
[forms]![search_form]![employee_last_name] or [forms]![search_form]![employee_last_name] is null
that works awesome until you try to put in another string, like for employee first name. Any help would be great, as i have never done this before and am eager to get it working.