Here is my issue. I have a main form that has two subforms, subform1 and subform2, both connected to the main form.
When I enter data into a field in subform1 I want subform2 to requery and update to show the calculated results from the new or changed data in subform1.
I found that if I do a refresh it works when changing the data but not when entering a new line of data in subform1. I tried some code in the after update field of on subform1, but cannot seem to get anything to work.
Me.[subform2].Form.Requery Does not work.
It errors and says it cannot recognize subform2 as a field.
I have tried a field name on subform2 but I still got the same error.
Thanks for any help I can get.