I have a table named tblScanned with one field ProctorID. I have a form named Form1 with a unbound box called Test.
The ProctorID field is a number.
Below is the code. I compiled the code and I get a syntax error message.
After I scan in the number, I want to clear out the unbound box called Test.
Any help would be appreciated.
Thanks.
Patrick
Private Sub Test_Click()
Dim strSQL As Integer
strSQL = "Insert Into tblScanned(ProctorID) Values ('"&Me!Test&"');"
Debug.Print strSQL
CurrentDb.Execute strSQL
Me!Test = " "
End Sub
The ProctorID field is a number.
Below is the code. I compiled the code and I get a syntax error message.
After I scan in the number, I want to clear out the unbound box called Test.
Any help would be appreciated.
Thanks.
Patrick
Private Sub Test_Click()
Dim strSQL As Integer
strSQL = "Insert Into tblScanned(ProctorID) Values ('"&Me!Test&"');"
Debug.Print strSQL
CurrentDb.Execute strSQL
Me!Test = " "
End Sub