I have a form with an unbound textbox called EMPLOYEENO1 through EMPLOYEENO5 and FNAME1 through FNAME5. I would like to make it so that as the data inside of EMPLOYEENO changes the FNAME updates.
FNAME would update from a query called EMPLOYEENO that contains EMPLOYEENO and NAME.
I have gotten it so On Lost Focus updates the FNAME by using the following code.
Private Sub EMPLOYEENO2_LostFocus()
FNAME2 = DLookup("NAME", "EMPLOYEENO", "EMPLOYEENO=" & "EMPLOYEENO2")
End Sub
Is there a way to use On Change to update the information in real time?
FNAME would update from a query called EMPLOYEENO that contains EMPLOYEENO and NAME.
I have gotten it so On Lost Focus updates the FNAME by using the following code.
Private Sub EMPLOYEENO2_LostFocus()
FNAME2 = DLookup("NAME", "EMPLOYEENO", "EMPLOYEENO=" & "EMPLOYEENO2")
End Sub
Is there a way to use On Change to update the information in real time?