Hello. I have a sub form which displays patient address located within another subform (which displays patient name, phone #, contact dates, etc.). The address sub form should allow users to add or edit addresses. When I make changes to an address or add a new one I often get a write conflict error (even though I am the only person in the database). The error does not always appear (usually, but not always) and I can't figure out the cause of the error.
The address sub form is based off of a query of the address table. The query seems to work correctly. I can edit records and add new ones in the query. The main form and other sub form do not include any of the address table's fields (aside from the foreign key- Pat ID DMS). The sub forms are linked using PAT ID DMS which is a foreign key in the pat address table.
There are several bound combo boxes on the address sub form displaying values from look-up tables (such as direction, street type, etc). The patient address table has an auto number primary key. The database has a SQL Server backend with an Access 2013 front end. The pat address table has a row version field/time stamp.
Below is a view of the address sub form and the record source query. The query is simple. It just pulls the fields from the patient address table and it seems to work correctly. I have tried adding code like the following to different controls: refresh, if me.dirty then me.dirty = false, and docmd.runcommand accmdsave record, but the problem remains. I'm not sure what else to try. Please help!