There are 2 mainforms and both of them share a subform. This subform is an add subform and I want the mainform to be refreshed after the data entry.
Prior to the sharing, I had it coded it the way below and it works fine
How would I recode this requery when it shared between 2 forms. frmMainformnoproc is the name of one of the main forms.
Thinking about this problem a little bit.
The code above was present after an update was completed in the subform. Maybe I should be doing it after I close the subform and refresh the mainform.
Based on that line of thinking I tried to add the code in the Activate event / Got Focus event of the mainform but the form did not get refreshed.
The code was obviously different as
Me!frmActiveTasks.Requery
Prior to the sharing, I had it coded it the way below and it works fine
Code:
Forms![B]frmMainformnoproc[/B]!frmActiveTasks.Requery
How would I recode this requery when it shared between 2 forms. frmMainformnoproc is the name of one of the main forms.
Thinking about this problem a little bit.
The code above was present after an update was completed in the subform. Maybe I should be doing it after I close the subform and refresh the mainform.
Based on that line of thinking I tried to add the code in the Activate event / Got Focus event of the mainform but the form did not get refreshed.
The code was obviously different as
Me!frmActiveTasks.Requery
Last edited: