Requery a form - after deleting a record it hangs

[Elana]

I have main form and two subforms. The first subform (frmMasterRequest)shows Master Payment Requests, the second subform (frmRequestSub) shows the percentage breakdown by subscriber for the master payment request. Master and subRequests are stored in two different tables (cascading deletes).

In frmMasterRequests OnCurrent event, I requery frmRequestSub so for each record in the Master, the second form shows the breakdown. This all works great, unless I want to delete a record on frmMasterRequests. Then the app hangs in a perpetual mode of "calculating".

Can someone give me an idea of what is happening here and how to solve the problem?

Thanks much!