K
karim
Hello All,
I am trying to write a qry that will be filtered by some pop-ups
when the user open it. What I want to do is for the customer pop-up, if the
user don't type the customer's name, it would show all the customers and
ignore the empty space. I tryed "Is Null" in the criteria area before and
after the [type cutomer name] and it did not work. I also tryed it on a
separate row and it also did not work. Does anyone know of a way that works?
Thanks for the help.
I am trying to write a qry that will be filtered by some pop-ups
when the user open it. What I want to do is for the customer pop-up, if the
user don't type the customer's name, it would show all the customers and
ignore the empty space. I tryed "Is Null" in the criteria area before and
after the [type cutomer name] and it did not work. I also tryed it on a
separate row and it also did not work. Does anyone know of a way that works?
Thanks for the help.