>hello:
>
>I'm trying to update my users table when they log in to my application
>with the date and time, it does this but also updates the last record(the last user) in my users file with the date and time. when I step through in the debugger it is on the correct record, why would it also go to the bottom of the file and update this user as well?
>Here is my code which is in the valid of my command button(enter button)
>Any input would be appreciated. Thanks.
>
>If upper(allt(ThisForm.text2.value)) = upper(allt(Users.Password))
> select users
> set order to username
> crec= recno()
> go crec
> User = Users.c_id
> useview = Users.view
> useupd = Users.update
> replace users.date_in with DATE(), users.time_in with TIME(), users.date_out with { / / }, users.time_out with ""
> Thisformset.Catstoolbar1.visible = .T.
> Thisformset.frmmain.visible = .T.
> thisformset.form2.visible = .F.
>
> Else
> =messagebox("Invalid Username and Password, Try Again !"),16, "CATS")
> Return
> Endif

Why the need to use GO TO command still? As I see it, the pointer already points to the current user.