Dlookup a value and displaying it on a form

[swmagic]

This is probably an easy one.

I have an SSN that the user types into form field.

The Dlookup (which works) should display the result back to the form in the Exit Event Procedure for the SSN field that that they type in.

[Forms].[frmAddSBNbr].[Last Name] = DLookup("[Last Name]", "tblEmployee", "[SSN] = '" & [StaffSSN] & "'")

My syntax is wrong. What would correct this and display the results in the same form that contains the SSN?

Thanks!

 

[PHV]

Have you tried the AfterUpdate event instead ?

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