Hi!

How do i count the number of times someone enters a wrong password on a login form? I think i have to use public variables but am uncertain of the HOW and the DO I OR DONT I?

PS: Would the code the same in Access 2000?

Regards
Rhys

You can use a public variable for this purpose.

You can define the public variable with module (form) scope as below.

option explicit
dim gbliNumLoginAttempts as integer

You have to put this outside any events.

Then you can increment it in each failed login attempt. When its value reaches 3, you can do the required action.

Actually,

Dim blabla As Integer doesnt work ... becoz you cant incremement it throughout the entire database. but using

Public blabla As Integer works perfectly.. thx!

Really. That was a mistake made by me. Sorry.