dawsonrhodes
Member
- Local time
- Today, 04:41
- Joined
- Mar 8, 2020
- Messages
- 85
Hola,
I'm just making a form that will add users in for a login page, there are two categories of users, employees and management. if a checkbox is clicked before update, the information recorded in the control source tblUsers will be added to tblUsersKey (the exact same collums and setup)
Here is what I have so far
The fields are [UserID] (for tblUsers}, [UserIDKey] {for tblUsersKey), [Username], [Password], [FirstName], and [LastName]
Thank you in advance for any help.
I'm just making a form that will add users in for a login page, there are two categories of users, employees and management. if a checkbox is clicked before update, the information recorded in the control source tblUsers will be added to tblUsersKey (the exact same collums and setup)
Here is what I have so far
Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim strSQL As String
If Check154.Value = True Then
If Me.NewRecord Then
'run and hide warnings
DoCmd.SetWarnings False
DoCmd.RunSQL strSQL
DoCmd.SetWarnings True
End If
End Sub
The fields are [UserID] (for tblUsers}, [UserIDKey] {for tblUsersKey), [Username], [Password], [FirstName], and [LastName]
Thank you in advance for any help.