Form Requery

[Guest]

I am working on a financial tracking system based on only three primary
tables, but with a variety of queries to perform calculations. I am using
three forms to prove ledger style entry pages with totals list in other
subforms from the appropriate queries. The problem is, when I change
information in one sumform or add a new record from my ADD Ledger Entry form,
I can't figure out how to update the whole page. Is there a way to requery
other items on a form when changing info on another subform? Help me! Thank
You

 

[Guest]

If I understand you correctly, you want to requery a parent form when you
make a change in one of its subforms. If that it, this statement will do the
trick:

Me.Parent.Requery

If the parent form has other subforms that have linked fields, they will
requery automatically as well.

HTH,
Barry

 

[Guest]

Thank you for responding so quickly. Where do I put that statement? I am not
a Visual Basic wiz. Thanks.

 

[Guest]

You could probably put it in the subform's AfterUpdate event. Select the
subform, click the elipsis (...) at the end of the After Update event line,
and select Code Builder. Enter it in that event:

Private Sub Form_AfterUpdate()
Me.Parent.Requery
End Sub

Barry

 

[Guest]

Worked like a charm! Thank you so much.

You could probably put it in the subform's AfterUpdate event. Select the
subform, click the elipsis (...) at the end of the After Update event line,
and select Code Builder. Enter it in that event:

Private Sub Form_AfterUpdate()
Me.Parent.Requery
End Sub

Barry