Hi, I am going to go crazy over this. My search works and it doesn't work. I have a form that will filter another form by either the ID number and/or Status. Both of these fields are unbound comboboxes
Everything seems to work except when I search by the first name on the list, it doesn't bring up any results when there should be or when I search the last status (test) it doesn't provide a match. Or If I select the first name on the list and first Status(Open) it doesn't filter correctly What could be causing this.