Lookup value in a table

[Guest]

I am using a form for data entry which is bound to tlbLetter. After entering
a loan number in a field in the form , I want a message box to tell me if the
loan number is in a different table called tblImport. Can someone help me
with the code on this? Thanks...

 

[Duncan Bachen]

I am using a form for data entry which is bound to tlbLetter. After entering
a loan number in a field in the form , I want a message box to tell me if the
loan number is in a different table called tblImport. Can someone help me
with the code on this? Thanks...

You can use the Dlookup Function in the After Update event of the text
control on the form.

Sample:

If DLookup("[LoanID]","[tblImport]","[LoanNumber]=" &
txtLoanNumberOnForm) Then
MsgBox "Already Exists"
End If

 

[Guest]

This is just what I was looking for. THanks a million.

I am using a form for data entry which is bound to tlbLetter. After entering
a loan number in a field in the form , I want a message box to tell me if the
loan number is in a different table called tblImport. Can someone help me
with the code on this? Thanks...

You can use the Dlookup Function in the After Update event of the text
control on the form.

Sample:

If DLookup("[LoanID]","[tblImport]","[LoanNumber]=" &
txtLoanNumberOnForm) Then
MsgBox "Already Exists"
End If