subform refresh

[Guest]

I've got two subforms that are linked with the same underlying table. I used
two forms to make data entry easier. Subform 1 displays circuit details,
Subform2 displays scheduled dates and statuses for those circuits. I can
jump back and forth between the two by clicking command buttons that set the
visible properties.

My problem is, when I enter the circuit details on the first subform, then
jump to the 2nd subform to add dates, the details I just entered aren't
there. If I close the main form and open it again, the details are there on
both subforms, but not until I close the main form. Can you help?

Thank you!

 

[Carl Rapson]

I've got two subforms that are linked with the same underlying table. I
used
two forms to make data entry easier. Subform 1 displays circuit details,
Subform2 displays scheduled dates and statuses for those circuits. I can
jump back and forth between the two by clicking command buttons that set
the
visible properties.

My problem is, when I enter the circuit details on the first subform, then
jump to the 2nd subform to add dates, the details I just entered aren't
there. If I close the main form and open it again, the details are there
on
both subforms, but not until I close the main form. Can you help?

Thank you!

In the command button Click events you could have each subform requery its
RecordSource:

Me.subform1.Form.Requery
Me.subform2.Form.Requery

I can't guarantee that'll work, but it's worth a try.

Carl Rapson

 

[Guest]

It worked! I had tried other "requery" code, but not quite right. That did
the trick, thanks so much!