Hi Jane,
>The user enters a password only when selecting new, delete, save. Otherwise a password doesnt have to be entered. It has to be done each time the user clicks on those buttons. I'm not certain where to set visible to .t. for password textbox visible & I'm not certain where to check that the password has been entered & that it is valid.
Well then, in the Click of the button do:
DO FORM Login TO lLoggedIn
The from will be modal. It will should have two textbxes on it, one for Username and one for Password, and two buttons, OK and CANCEL. You will need to have a table to contain the USERNAME and PASSWORD. The Cancel buttonwill always be enabled, you will enabled the OK button in the lostfocus events if the Username textbox could be SEEKed in the USERS Table and the Password textbox matches the password value in the table for the corresponding USERNAME. Then (I'm sorry but I forgot the method to do this in) but return .F. if the user pressed cancel and .T. if OK. Then your code for the click event looks like:
DO FORM Login TO lLoggedIn
if lLoggedIn
endif
Let me know if this method is not acceptable in your situation.