if statement with "or"

[slimjen]

Hi all. Using access 2007. I have some generic code for users to logon to a database using their windows api. The only way I know to retrict a user to a form or to a record only they own is on form load.

If GetNetworkUserName <> "jdoe"  or <> "janedoe" 
then 
msgbox "you don't have permission to access this form

It only half works. If <> "jdoe" works but <> "janedoe" doesn't.


How can this code work with or?
Thanks

[Rod]

If GetNetworkUserName <> "jdoe" Or GetNetworkUserName <> "janedoe" then

You have to pedantically repeat the variable name for every comparison.

[pbaldy]

Further, with the <> test, you want And rather than Or.

[Rod]

Well spotted Paul, I missed that.

[pbaldy]

No problemo!