I have a SQL Server Backend One of the tables tracks Appointments Fields include
ApptID Identity Field
PersonID Foreign Key to the person table
ApptDate Date of the appointment
ApptStatus 3 choices (Appoinment Scheduled, Appointment Kept, Appointment Missed.
The table is populated from An Access 2010 Database Front end with a subform on the Person page Linking the person page to the appointment subform with the PersonID Field. The ApptID field is on the form but Visible is set to no so the user doesn't see it. The issue is everytime I try to insert a new appointment I get the error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert explicit value for identity column in table 'tbl_Appointments' when IDENTITY_INSERT is set to OFF.(#544)
I have other subforms with similar data structure that work fine. It's just this one that doesn't. The user doesn't have the ability to change it I don't insert any value for the identity column or the Person ID Column. the only 2 fields that are changed are the 2 displayed Date of the Appointment and ApptStatus. If I open the table in Access and enter the information it works as it should. It's only in the form that I'm having an issue. Anybody have a thought.