I have this simple query:
Code:
strSQL = "INSERT INTO tblEngParRole (Eng_ID, Person_ID, ParticipantNumber, Role)" & "VALUES(" & Me.Eng_ID & "," & .ItemData(n) & "," & 1 & "," & '" & Me.txtParRole1 & "' & ")"
What I am expecting to be inserted into the Role field in the table is the information typed into the text box,...