DLookUp Function

[IanDJDavies]

Hi All ... Please Help!



I am creating a login form and after I update the Username I want a txt box to show the full name of the user .. I call it the Display name. The following I have put on the After Update ..

txt_Display = Dlookup("[DisplayName]",tbl_Users,"[Username]=" &Forms! frm_SystemEntry![txt_UserName])

Code is wrong I know as it shows blank. Little help as this is my first program for college.

Thanks

[pbaldy]

See if this helps:

http://www.theaccessweb.com/general/gen0018.htm

[Missinglinq]

Looking at the site Paul gave you a link to, you'll note that your syntax

"[Username]=" & Forms! frm_SystemEntry![txt_UserName])

is only correct if Username is defined as a Number, which seems unlikely. For a Field defined as Text, the syntax would be

"[Username]='" & Forms! frm_SystemEntry![txt_UserName] & "'")

Assuming that frm_SystemEntry is the Form this code appears in, you could simply use

"[Username]='" & Me.txt_UserName & "'")

Linq ;0)>

[pbaldy]

If you're going to give out fish, mention the table name needing to be in quotes too.

[Missinglinq]

Good catch...missed that!