I have a continuous subform with a record counter on the main form.
When I delete a record from the subform the record counter on the main form does not update immediately.
I have requery and refresh just about every where but it will not update until I close and reopen.
How can I be programming with access for 20 years and not answer this stupid question. Why is something so basic so difficult in access (2002)