INSERT INTO STATEMENT ERROR
Currentdb.Execute "INSERT INTO tblRegister(Surname,FirstN
" VALUES(" & Me.txtSurname & ",'" & Me.txtFName & "','" & Me.txtMName & "','" & Me.txtEmail & "')"
The code above gives me run time error 3061: Too Few parameter: expected 1
Also, I discovered that when I typed (1) the figure (1) into the surname textbox on my form. It inserts into the table tblRegister without the error. How can I make it insert name (letter) into the surname and not a number? Thanks in advance for the answer
" VALUES(" & Me.txtSurname & ",'" & Me.txtFName & "','" & Me.txtMName & "','" & Me.txtEmail & "')"
The code above gives me run time error 3061: Too Few parameter: expected 1
Also, I discovered that when I typed (1) the figure (1) into the surname textbox on my form. It inserts into the table tblRegister without the error. How can I make it insert name (letter) into the surname and not a number? Thanks in advance for the answer
