refresh subform data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have the same subform use on 2 diffrent tabs within the same main form
because the users need to see this information for these 2 tasks....

However, I am unable to update the other subform when the other one gets
data input into it. How can this be done? No matter which subform the user
uses, I need the other one to refresh the data it displays so that if the
user switches over to the other tab they are always displayed the most
recent/updated information.

Thank you,

Daniel
 
I've tried using the After_Update event but must be doing something wrong.

I manage to get any changes to existing data updated between both forms but
new data does not get pushed to the 2nd form???

I hope this helps.

Daniel
 
In the After_Update event I tried:

Me.dirty=false 'commit data
Forms!mainformname.subformname.Form.Requery
Forms!mainformname.subformname.Form.Refresh

but it does synchronize the data. If I close the main form and then re-open
the data is in sink again until the user adds a new entry.

What technique is use to display data within two subforms?

Daniel
 
Back
Top