this is my query:
DoCmd.RunSQL "INSERT INTO CUSTOMERDETAILS (CUSTOMERID, CUSTOMERNAME, CUSTOMERADDRESS, CONTACT, EMAIL, ORGANIZATIONTYPE, ORGANIZATIONID,STATUS) VALUES (" & Me.CUSTOMERID.Value & ", '" & Me.cusname.Value & "', '" & Me.cusaddress.Value & "', '" & Me.CONTACT.Value & "', '" & Me.EMAIL.Value & "', '" & Me.orgtype.Value & "', '" & Me.orgid.Value & "', " & stat & ");"
i have checked all my field names and they are correct. i have copied and pasted the field names just to be sure.
stat is an integer variable with the value of 1.
Please help.