Dear friends
anyone help my i want to add record thought add button but when i click on add but its showing error
run time error '3075' :banghead:
Coding...
Private Sub cmdAdd_Click()
'add data to table
CurrentDb.Execute "INSERT INTO student(stdid, stdname, gender, phone, address) " & _
" VALUES(" & Me.txtID & "','" & Me.txtName & "','" & Me.cbcgender & "','" & Me.txtphone & "','" & Me.txtaddress & "')"
'clear form
cmd.clear_click
'refresh data in list on form
frmstudentsub.Form.Requery
End Sub
anyone help my i want to add record thought add button but when i click on add but its showing error
run time error '3075' :banghead:
Coding...
Private Sub cmdAdd_Click()
'add data to table
CurrentDb.Execute "INSERT INTO student(stdid, stdname, gender, phone, address) " & _
" VALUES(" & Me.txtID & "','" & Me.txtName & "','" & Me.cbcgender & "','" & Me.txtphone & "','" & Me.txtaddress & "')"
'clear form
cmd.clear_click
'refresh data in list on form
frmstudentsub.Form.Requery
End Sub