2 subforms on a main form - both subforms not refreshing

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

Guest

Hi,

I have 2 subforms on a main form. From the main form you can choose what
each subform will display which is working great.

In the subforms you can edit info which can change the info that will be
displayed in the other subform. The problem that I am having is that when
data is edited in one of the subforms, I cannot get it to refresh the other
subform to show updated data automatically. I can refresh the subform I am in
just fine.

I am working in Access 2000 and have done this just fine before ages ago in
Access 97. However the old way i used to do it no longer works anymore.

Thanks in advance.
 
Lythandra said:
I have 2 subforms on a main form. From the main form you can choose what
each subform will display which is working great.

In the subforms you can edit info which can change the info that will be
displayed in the other subform. The problem that I am having is that when
data is edited in one of the subforms, I cannot get it to refresh the other
subform to show updated data automatically. I can refresh the subform I am in
just fine.

I am working in Access 2000 and have done this just fine before ages ago in
Access 97. However the old way i used to do it no longer works anymore.
Click to expand...


I am unaware of any changes in how this works since A2

Code in sibform1 to "refresh" the data in subform2:

Me.Parent.othersubformcontrol.Form.Requery
 
Thankee, you got me on the right path. I got it.

Marshall Barton said:
I am unaware of any changes in how this works since A2

Code in sibform1 to "refresh" the data in subform2:

Me.Parent.othersubformcontrol.Form.Requery
Click to expand...
 
Back
Top