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
when i step thru it i'm getting a error 3075 for syntax error (missing operator) in query expression 'me.txtname=' . any ideals?Code:txtLocID = DLookup("[locationid]", "2lognamet", "me.txtname=" & DsID)