Think of the rivers of blood spilled by all those generals and emperors so that in glory and in triumph they could become the "Momentary" masters of a "Fraction" of a "Dot."
I have 3 fields I would like to search all at ones. Two of the fields I need to be exactly like them or left blank in the search criteria. So for mine it is part number/department/request type.
The part number field can be a "like "*" & [forms]![myform]![partnumsearch] & "*" Or is null". This works with no issues.
The problem I am having is when I do the department box I try "= [forms]![myform]![departsearch] or is null" and this does not work at all.
I haven't even started on the request type box as it will be the same as the department search and I can't seem to get that one working. Anyone have any ideas?
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
