Checking for password = null

[planetdrouin]

I currently have a form that allows users to change their password. But I would like to run a function at startup to check if the user's password is null which would then open the form. Does anyone know the proper syntax to check existing password?

Thanks

Lawrence

 

[Zeroanarchy]

If [field1]is Null then
Docmd.openform, "Form2"

That should do it

Zero Anarchy

 

[planetdrouin]

I know about "is null", but how do I reference the password field in the database security?

Lawrence

 

[Zeroanarchy]

is it you are trying to refer to the access inbuilt security or is the form refering to a security table?

 

[planetdrouin]

The built in Access security.

Lawrence

 

[planetdrouin]

For an answer check out thread705-195900.

Lawrence