What is the DataSession for the form (find this property in the Property sheet). Is it private or default?
If this is a private datasession, when do you open the Users table? In the form's Data Environment?
I used to prefer to open tables myself in the Load event of the form without using form's DE at all.
In other words, in form's Load event you may have
use Users in 0 alias Users shared && This command may easily fail in case the Users table is already opened exclusively or by some other reasons.
Also you may try to use Debugger. I don't know if Tamar's Granor session on the Debugger is available in some sort of a video, this would be beneficial to you...
UPDATE. How hard the old bad habits die! I need to learn how to spell "beneficial"...
>Wow that is cool it says Alias users is not found the .sbf file inside the .dbc is users.dbf the fields are userid, username and password so I don't understand the code I am still trying is Jim B. and again alias not found, here is a copy of the lines of code
>
>
>
>if Users.Password == PADR(ALLTRIM(thisform.txtPassword.value),LEN("Users.Password"))
> else
> endif
>RELEASE thisform
>DO FORM C:\HPRC\MANAGEMENT.SCX
>
>
>
>If you have any ideas I appreciate it.
>
>Thanks,
>
>Fred W.
If it's not broken, fix it until it is.
My Blog