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