Hi -
I've been trying a different things recommended on this board, but I'm still running into problems. Can anyone tell me what I'm doing wrong?
I have a main form with 2 subforms. My main goal is for Subform A to update with updated information from Subform B. At first, in the Form Properties of Subform B, I added a requery statement in the After Update Event - to requery Subform A.
Forms!frmPROPOSALSetup!subfrmPROPOSALSetup.Form.Requery
To test it out, I opened the main form, went to record #4 and made a change to Subform B. Subform A updated BUT I found myself back at record #1 of the main form. I wanted subform to update BUT I wanted to stay on the main form's current record.
So then I tried adding the same line of code to the After Update Event of a field on Subform B... that didn't work either. Actually no updating occurred at all.
How can I refresh/requery the contents of Subform A and keep the focus on the current record in the main form?
I appreciate all ideas. Thanks!
I've been trying a different things recommended on this board, but I'm still running into problems. Can anyone tell me what I'm doing wrong?
I have a main form with 2 subforms. My main goal is for Subform A to update with updated information from Subform B. At first, in the Form Properties of Subform B, I added a requery statement in the After Update Event - to requery Subform A.
Forms!frmPROPOSALSetup!subfrmPROPOSALSetup.Form.Requery
To test it out, I opened the main form, went to record #4 and made a change to Subform B. Subform A updated BUT I found myself back at record #1 of the main form. I wanted subform to update BUT I wanted to stay on the main form's current record.
So then I tried adding the same line of code to the After Update Event of a field on Subform B... that didn't work either. Actually no updating occurred at all.
How can I refresh/requery the contents of Subform A and keep the focus on the current record in the main form?
I appreciate all ideas. Thanks!
