Validate from Dlookup

[lisaharris]

I have an application where users enter information into a form. There is an existing dlookup that returns the customer name based on the customer number entered. The customer name is not stored in the table, only the customer number. This is the functioning dlookup: =DLookUp("[CustName]","CUSTOMERS","[Custno]=[ID]")

How can I validate that the customer number is correct and disallow the user from continuing if the customer number does not exist in the CUSTOMERS table? I tried putting a validation rule on the field that shows the dlookup but it caused a SQL connection error.

Any ideas greatly appreciated.


__________
Veni, Vidi, Visa: I came, I saw, I charged it.

 

[PHV]

Why not simply use a ComboBox for your ID control.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886