I have a table named frmNew with 3 fields; CustomerNo, Except and Status.
The status can either be open or closed.

I have a form named, frmNew with 3 text boxes of txtCusNo, Except.

I want a vba code (preferrably, with Dlookup) that will look up the CustomerNo on the table anytime a customer number is specified in the txtCusNo and if the status is open, it should show a messagebox of "I like this".