>OK so I figured out what you meant by bound I used a builder fixed that and now the form runs with UserID but when I enter a password and click OK... The following was opened in the trace window (2nd time I have even used it) anyhow these 2 lines from command2 are the errors:
>
>Indes tag not found
>on this line
>Seek(rtrim(thisform.txtUserID.value), 'Users','txtUserID')
>
>and
>
The last parameter in the SEEK function is the name of the Index tag in the table. In your case it's probably just UserID. Check SEEK() function in the Help file.
>variable PASSWORD is not found
>on this line
>if rtrim(Users.Password) = rtrim(thisform.txtPassword.value)
>
>Thanks for helping I am done with this inventory program except for this last thing I HOPE
>
>AGAIN THANK YOU FOR ALL !!!
>
>Sincerely
>
>Fred W.
Verify again the name of the field in the Users table which you're comparing with the value of the textbox on your form.
If it's not broken, fix it until it is.
My Blog