I have the below sql statement which works fine...Id like to expand it so i can copy multiple values from the form into the same table.
EG: id like to copy values from sig2, sig3 sig4 etc..text92 would remain unchanged.
EG: id like to copy values from sig2, sig3 sig4 etc..text92 would remain unchanged.
PHP:
Private Sub CmdSave_Click()
If Me.CmdSave.Visible = "True" Then
sql = "INSERT INTO TBL_Pick_Selection([Employee_ID],[Date_Selected])" _
& "VALUES ('" & Me.Text92 & "','" & Me.Sig1 & "')"
CurrentDb.Execute sql
Else
End If
End Sub