Recordset changed to snapshot

[sdforsb]

Somehow my form quit working. (?) The form has a series of textboxes that load from code and an add record button that should add a record to the table. When any connected textbox attempts to load, error code 3326 appears. Somehow the dynaset recordset has change to snapshot. The form's recordset type property is set to dynaset. How do I fix it?

Thanks for your help.

 

[pr2-eugin]

Hello sdforsb, Welcome to AWF..

Is the AllowAdditions property set to True? What is the record source of the Form?

 

[sdforsb]

Thanks for the response Paul.

AllowAdditons is set to True.

The query is a select query calling fields in the single table where a record is to be added.

SELECT tblStudentRecord.CourseID, tblStudentRecord.CourseDate, tblStudentRecord.Location, tblStudentRecord.Track, tblStudentRecord.StuEmail, tblStudentRecord.RegistrationDate
FROM tblStudentRecord
WHERE tblStudentRecord.CourseDate>DateAdd("d",-40,Date());

The first five fields in the query make up the primary key for the table.

 

[sdforsb]

Computer lock up. Booted and Form works now.

Thanks Paul.