I am trying to implement DLookup for the following sql to a linked SQL Server table to verify that the currentuser is in my Traders table:
select tr_username from Traders where tr_username='edobbie'
When I enter the following DLookup command I get the error 'compile error expected ='
The offending line is:
DLookup("tr_username","Traders","[tr_username] = " &CurrentUser())
The Editor doesn't seem to see the = sign in my criteria. I've modified the syntax a number of ways to no avail.
Does anyone see the problem?
select tr_username from Traders where tr_username='edobbie'
When I enter the following DLookup command I get the error 'compile error expected ='
The offending line is:
DLookup("tr_username","Traders","[tr_username] = " &CurrentUser())
The Editor doesn't seem to see the = sign in my criteria. I've modified the syntax a number of ways to no avail.
Does anyone see the problem?