>>>I have a login form that allows a user 6 attempts to log into an application and a logical field in a users table called locked. After 6 attempts I would like to programmatically change this field to .T. but I can't figure out how to do it. Any ideas?
>I've read the question slightly differently. Wouldn't you have a property in the form and that would be a counter, incremented by 1 each time the user tries to get in. After 6 - bang they're out. Then you'd change the field to .t. and exit.
>
>If I were doing this and there was to be a timeout before they could try again I'd change the logical field to a datetime or date field and next time they login the program checks the right amount of time has elapsed since the last unsuccessful login (would normally be heaps). I've found that making changes directly to the table isn't as successful as working through hidden fields on a form.
>
>good luck - Sarah :)

Actually, the way I have this set up is to have a System Administrator unlock the login. I think this is a bit more secure for the purpose I have in mind for the app I am going to design. The idiotic thing I did was not specifying the contolsource in the form itself. But I appreciate all the suggestions.

Thanks,