I know this question has been asked many times; however, I cannot find a solution that works for me.
Background:
I have a form that is based on a two-table query with two embedded subforms that are based on tables. This worked fine. However, I made several changes to my db and now when I open this form I get this error message. I am also not able to add any new records.
So far, I have tried the following to retify the problem:
1) I checked the parent/child relationships on the subforms. Everything checked out.
2) I checked for conflicts in the Event tab of the form to see if there was any conflicts in the "Before Update" event. There were none.
3) I attempted to enter a record in both the underlying query and table. No problems there.
Any ideas?
Background:
I have a form that is based on a two-table query with two embedded subforms that are based on tables. This worked fine. However, I made several changes to my db and now when I open this form I get this error message. I am also not able to add any new records.
So far, I have tried the following to retify the problem:
1) I checked the parent/child relationships on the subforms. Everything checked out.
2) I checked for conflicts in the Event tab of the form to see if there was any conflicts in the "Before Update" event. There were none.
3) I attempted to enter a record in both the underlying query and table. No problems there.
Any ideas?