2 line Validation Situation .... HELP....plz!!!!

[jas_1]

Hey,

I'm trying to set up a validation behind a text box in access and I want it to find certain values in a table. Unfortuantly I am having a problem with this piece of code a few lines long:

I am trying to perform a procedure which checks whether a customer in a table already exists by comparing First, Last Name and Post Code. Unfortunatly I have a probelm in the FirstName variable. This is what I have tried:



FirstName = DLookup("FName", "CustomerInfo", "[CustomerInfo]![CustID] = LCustomerID")

Where
LCustomerID = DLookup("CustID", "CustomerInfo", "[CustomerInfo]![LName] = Forms![Add_Customer]![txtLName]")

But this did not work So I tried this:

FirstName = DLookup("FName", "CustomerInfo", "[CustomerInfo]![CustID] =(DLookup("CustID", "CustomerInfo", "[CustomerInfo]![LName] = Forms![Add_Customer]![txtLName]"))")

Still does not work

Can anyone help me with this problem? I will be very greatful

[chrisjk]

Can you stop cross-posting (in General VB and Database Dev). Also you posted the same question twice in each forum within about 15 minutes of each other. If nobody knew the first time, they aren't going to know the second time. Don't hog space, we don't need 4 posts asking the same thing.

As for your request, this is wrong.

FirstName = DLookup("FName", "CustomerInfo", "[CustomerInfo]![CustID] = LCustomerID")

It should be

FirstName = DLookup("FName", "CustomerInfo", "[CustomerInfo]![CustID] = " LCustomerID)

(no quotes around numbers!!)

[jas_1]

error message: expected list or separator
LcustomerID highlighted?????

[chrisjk]

In that case try

FirstName = DLookup("FName", "CustomerInfo", "[CustomerInfo]![CustID] = " & LCustomerID