Hi, my question for you is: I have a form that runs off a query that has two parameters, one for a supplier ID and the other for a product code, there is also a subform. I have tried to have a msgbox come up if there is no product code found and then don't open the form with no luck. Can anyone help me.
Thanks

What code have you tried and where did you use it?

Hi, I have just solved my problem. What I did was use a macro to check the field: IsNull([Forms]![frmProduct].[item_code]), then give a message box. Works OK, thanks for your reply.