pass SQL statement results to text box control 2

[vttech]

I have a text box(txtUserLogon) on my form(frmLogInOut) that I would to have the following value

select empusername from tblEmployees where EmployeeID = forms!frmLogInOut!txtEmployeeID.value

I tried placing this in the control source and default value with no luck.
I created a query called qryUserName that is based on that sql statement but I can't figure how to pass that value on to the text box.


Any ideas or thoughts how to accomplish this goal??


Newbie in search of knowledge

 

[PHV]

Have a look at the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[randy700]

How about...

=DLookup("empusername", "tblEmployees", "EmployeeID = " & forms!frmLogInOut!txtEmployeeID)


Randy