gomez

Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\D&M.mdb" & ";Persist Security Info=False"
conn.CursorLocation = adUseClient
conn.Open
conn.Execute ("INSERT INTO RestZone(PhoneNumber) VALUES('2342342')")
conn.Close
Set conn = Nothing

my understanding of the SQL statement: RestZone = Name of table; PhoneNumber = Column in table; '2342342' = the value stored in table RestZone in Column PhoneNumber.. is this correct? If so, why do i keep getting "unknown field name: 'PhoneNumber'" it is spelled correctly.

/any ideas? thanks

gomez

lesson learned: make sure you refer to the correct table before asking stupid questions