I still need help with this run time error!!!!!!

[chubby]

I have check the spelling of my tables. Double checked the code and I still can't figure out the problem with my code. I'm still getting a run time error '3192'

Private Sub UIC_tbl_ID_NotInList(NewData As String, Response As Integer)
DoCmd.RunSQL ("INSERT INTO UIC_tbl_ID (UIC_tbl_ID_) VALUES ('" & NewData & "')&quot
Response = acDataErrAdded
Me.UIC_tbl_ID.SetFocus

End Sub

 

[DougP]

Is this Access or SQL Server table???
You have to do it like so in Access. "Values" does not work.

example 1: gets data from another table

INSERT INTO Grocerys1 ( Barcode, Description )
SELECT Grocerys.Barcode, Grocerys.Description
FROM Grocerys;

Example 2: data from other variables

INSERT INTO Grocerys1 ( Barcode, Description )
SELECT 35335 AS expr1, [flour] AS expr2;

Access is weird but that works



DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive