I’m receiving the error “Item not found in this collection” when running the following:
Private Sub CmdAddRecord_Click()
Dim db As DAO.Database
Dim rst As DAO.Recordset
On Error GoTo ErrHandler
Set db = CurrentDb
Set rst = db.OpenRecordset(“tblData”)
With rst
rst.AddNew
rst!SURVEY_ID = ID
rst!QUESTION = “Q1”
rst!Comments = Q1
I have verified the following:
tblData exists
The fields [SURVEY_ID], [ question], and [COMMENTS] are fields in the table “tblData”, and
ID and Q1 are fields on the form.
Any suggestions?
