Refres main form from Subform

Topic

New Reply

When I change a record on the subform I want to refresh a textbox on the main form that is based on a DCount of the specific records on the subform. How could I do that but still return record I was on in the subforma fter the refresh? How would I code the after update of the control on the subform? I tried Me.PArent.text55.requery and it would not work. Should I use refresh or recalculate, or what should the proper syntax be? Thanks

Reply | Quote

Replies

Try

Me.Parent.Recalc

Reply | Quote

It still jumps back to the first record on the subfom.Istere any way to stay or retrn to the record I was editing

Try

Me.Parent.Recalc

Reply | Quote

Try this:

Place a text box in the header or footer of the subform that calculates the count you want. You may be able to use Count or Sum instead of DCount.
The text box may be hidden if you wish.
Place a text box on the main form that refers to the text box on the subform:

=[SubFormName]![TextBoxName]

No code needed. The text box on the main form will be recalculated automatically.

Reply | Quote