IN operator

[dougperk]

In the Autoexec macro I can insert either of the following expression into the IF command and it evaluates successfully.
UsernameWindows() = "Person1"
UsernameWindows() IN ("Person1", "Person2")

But if I try to use any of the following IN expressions, I receive an error upon save, stating the "Access cannot parse the expression".
UsernameWindows() IN (Select tblUserPermissions.UserName from tblUserPermissions)
UsernameWindows() IN (Select [tblUserPermissions].[UserName] from [tblUserPermissions])
UsernameWindows() IN (tblUserPermissions.UserName from tblUserPermissions)

How do I need to write that expression. Ideally I want it to also include a WHERE such as:
UsernameWindows() IN (Select tblUserPermissions.UserName from tblUserPermissions Where tblUserPermissions.OpenDashboard = "Yes")



Any suggestions?
Doug

[rpeare]

IN parses a string looking for a value if you want to look up a user from a table you would have to use dlookup or some other method to find the user for instance:

if dcount("*", "tblUserPermissions", "[UserName] = '" & usernamewindows() & "'") > 0 then

this would return a TRUE if the person's username existed in your table, FALSE if it didn't (count of records would be 0)

if you want to lookup a person's password you'd use dlookup like

sUserPW = dlookup("[UserPassword]", "tblUserPermissions", "[UserName] = '" & usernamewindows() & "'")