System crash with multiple subforms

W

Wouter

I have a mainform FormA with two subforms FormB and FormC;
FormB is linked to FormA and FormC to FormB. Whenever
values in FormB change, FormC recieves a Requery. This all
works very well. But when I delete a record in FormB,
Access crashes. The statusbar keeps "calculating...", my
CPU usage goes up to 100% and the only solution is to stop
Access using TaskManager.

The problem of course is the simultanious deleting and
requerying the same record, but how to prevent this?
Please help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top