I can't seem to get the following to work. Can anyone help?
Thank you.
Code:
DoCmd.RunSQL "UPDATE tblLogins INNER JOIN tblLogin ON tblLogins.UserID = tblLogin.UserID" _
& "SET tblLogins.UserPasswordChanged = 'Y', tblLogins.FirstLoginDate = Date(), tblLogins.FirstLoginTime = Time()" _
& "WHERE tblLogins.UserPasswordChanged ='N'"
Thank you.
Last edited by a moderator: