IIF field is null then

[honor401]

I have a query that I have polling a database with PO number
I have the query right now asking "what po do you want to print"
Can I make it reply with a msgbox that po not found if po field is null?
and would I put that in the criteria field?
thanks,
honor401

 

[ecniv]

Dont think so - you're using a parameter that the user specifies.

If you put it into a form then you could, because you could check the textbox first then proceed if it has a PO number.


Vince