J
JB
I am getting an error 3200 when I attempt to delete a parent record of
a child record that has just been deleted. Access deletes the record,
which is what I want, but then generates the error 3200, which I don't
want. Each record is on a separate form. If I open the linked form,
delete the child record, close the linked form and then try to delete
the parent record, I get the error 3200 and then the record is deleted.
I have checked the query and it is showing #Deleted#. I have set the
Form_Activate event to requery the underlying data source so it detects
the change in the source query. I have added code to the error handler
for it to analyze something on the form to determine if the child form
has a linked value. Despite these efforts, the error is still
generated.
I can't just ignore the error because sometimes it is legit and I need
the message to appear. The problem is erratic and does not happen every
time. I have traced it and can't find anything in the code that is
helping me. Does anyone have an idea?
a child record that has just been deleted. Access deletes the record,
which is what I want, but then generates the error 3200, which I don't
want. Each record is on a separate form. If I open the linked form,
delete the child record, close the linked form and then try to delete
the parent record, I get the error 3200 and then the record is deleted.
I have checked the query and it is showing #Deleted#. I have set the
Form_Activate event to requery the underlying data source so it detects
the change in the source query. I have added code to the error handler
for it to analyze something on the form to determine if the child form
has a linked value. Despite these efforts, the error is still
generated.
I can't just ignore the error because sometimes it is legit and I need
the message to appear. The problem is erratic and does not happen every
time. I have traced it and can't find anything in the code that is
helping me. Does anyone have an idea?