Naqibullah
Registered User.
- Local time
- Today, 19:43
- Joined
- Feb 7, 2013
- Messages
- 86
Dear Colleagues,
Greetings!
i have a continues form which lists members of a specific group, from this form, i want to insert some members (one by one) into a specific table which i already designed, but when i run insert command, i received an error.
Private Sub Command34_Click()
Dim sSQL As String
Set sSQL = "INSERT INTO VSLAMembertbl (VSLAID,MemberID) VALUES (" & Me.VSLAID & "," & Me.MemberID & ");"
DoCmd.RunSQL sSQL
End Sub
thanks in advance from you answers
Greetings!
i have a continues form which lists members of a specific group, from this form, i want to insert some members (one by one) into a specific table which i already designed, but when i run insert command, i received an error.
Private Sub Command34_Click()
Dim sSQL As String
Set sSQL = "INSERT INTO VSLAMembertbl (VSLAID,MemberID) VALUES (" & Me.VSLAID & "," & Me.MemberID & ");"
DoCmd.RunSQL sSQL
End Sub
thanks in advance from you answers