bentheimmigrant
Lost & confused
- Local time
- Today, 08:08
- Joined
- Aug 21, 2015
- Messages
- 60
I have a Parent form with some continuous Child subforms. These forms allow additions, edits, and deletions.
When the user enters data into certain fields, AfterUpdate fires some VBA to do some maths, and populate some fields in the Parent form. When you go back and edit one of these fields in a Child, it works, but when you try to edit a second one, you get a "No Current Record" error.
It seems that interacting with the Parent loses the focus on the current record, and nothing can fix it until either the Parent or Child is requeried. I've tried clicking out of and back into the Child, but you have to requery.
I could add a requery to the VBA, but that will be extremely annoying to anyone trying to enter data, as they'll always lose their place.
Any advice on how to keep my current record active while also populating parent form fields?
TIA
When the user enters data into certain fields, AfterUpdate fires some VBA to do some maths, and populate some fields in the Parent form. When you go back and edit one of these fields in a Child, it works, but when you try to edit a second one, you get a "No Current Record" error.
It seems that interacting with the Parent loses the focus on the current record, and nothing can fix it until either the Parent or Child is requeried. I've tried clicking out of and back into the Child, but you have to requery.
I could add a requery to the VBA, but that will be extremely annoying to anyone trying to enter data, as they'll always lose their place.
Any advice on how to keep my current record active while also populating parent form fields?
TIA