DLookup help

[vicsaccess]

i have two unbound text boxes. the first uses a module to pull the users log in name called txtname. the second txtlocid,i would like to compare that name to the table 2lognameT and display the location ID where txtname is equal to Dsid. i have

txtLocID = DLookup("[locationid]", "2lognamet", "me.txtname=" & DsID)

when i step thru it i'm getting a error 3075 for syntax error (missing operator) in query expression 'me.txtname=' . any ideals?

[orange]

Is DsId a number or text? If Text, try

txtLocID = DLookup("[locationid]", "2lognamet", "DsID = '" & me.txtname &"'")

[vicsaccess]

thanks orange, that did it. i figured it had something to do with the text but all my combinations were not working. i'll add that one to the library.