multiple critera problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have built a query that prompts the user to type in a Customer name, and a
Decison maker. The customer name is a combo box, and the decision maker is a
normal text box. If I select a customer from the combo box, and enter a
decision maker, I get my information. But let's say I don't know who the
decision maker is, and I just want to pull up by customer. Is there a way if
I leave the decision maker field blank, it will still pull up the customer
list?
 
In your criteria, change it to something like...

Like Forms![frmSomeFormName]![UserID] & "*"


Rick B
 
Back
Top