Hi there
Have searched the posts and FAQs, but not found anything, so if anyone can give me a hand, or refer me to a relevant post, I would greatly appreciate it.
Here is the problem. I have two subforms on a form. The second one is requeried using the on_current event of the first one:
This works well. However, when I delete a record in the first subform, microsoft access stops responding, and I eventually have to shut it down using the task manager.
Dos anyone know how to solve this problem?
Thanks!
James
Have searched the posts and FAQs, but not found anything, so if anyone can give me a hand, or refer me to a relevant post, I would greatly appreciate it.
Here is the problem. I have two subforms on a form. The second one is requeried using the on_current event of the first one:
Code:
Private Sub Form_Current()
[Forms]![Form1]![Subform1].Requery
End Sub
This works well. However, when I delete a record in the first subform, microsoft access stops responding, and I eventually have to shut it down using the task manager.
Dos anyone know how to solve this problem?
Thanks!
James