-
Dlookup and vba code request
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".
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules