Dlookup

[Inusah]

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".

 

[Minty]

Why not have a combo box with all three fields as columns and simply use that to select your customer number and display the status at the same time.

It also prevents typing in a non-existent customer number.

 

[Gasman]

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".

Here you go.

DLookup Function - Microsoft Support

Use the DLookup function in Access desktop databases to get the value of a particular field from a specified set of records.

support.microsoft.com

 

[Solo712]

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

As the saying goes: "There are three kinds of people: those who can count and those who can't".

Best,
Jiri

 

[Gasman]

Crossposted same day at http://www.vbaexpress.com/forum/showthread.php?70388-Dlookup-and-vba-code-request