More eficient way to requery?

[www]

Hello,

I set up a form with multiple text boxes that show the results of a DCount. Each text box pulls info from different tables and queries. I use 2 text boxes as date ranges and want all the aforementioned DCounts to refresh when the date range is changed. My current method works, but I wanted to know if there is a more efficient way to do this. Here is the code I have for "On Click"

Private Sub txt_str_dte_AfterUpdate()
Me.enftxt_1.Requery
Me.enftxt_2.Requery
Me.enftxt_3.Requery
Me.enftxt_4.Requery
Me.enftxt_5.Requery
Me.enftxt_6.Requery
Me.enftxt_7.Requery
Me.enftxt_8.Requery
Me.enftxt_9.Requery
Me.enftxt_10.Requery
Me.enftxt_11.Requery
Me.enftxt_12.Requery
Me.enftxt_13.Requery
Me.enftxt_14.Requery
Me.enftxt_15.Requery
Me.enftxt_16.Requery
Me.enftxt_17.Requery
Me.enftxt_18.Requery
Me.enftxt_19.Requery
Me.enftxt_20.Requery
Me.enftxt_21.Requery
Me.enftxt_22.Requery
Me.enftxt_23.Requery
Me.enftxt_24.Requery
Me.enftxt_25.Requery


Me.enftxt_26.Requery
Me.enftxt_27.Requery
Me.enftxt_28.Requery
Me.enftxt_29.Requery
Me.enftxt_30.Requery
Me.enftxt_31.Requery
Me.enftxt_32.Requery
Me.enftxt_33.Requery
Me.enftxt_34.Requery
Me.enftxt_35.Requery


End Sub

[CJ_London]

just

me.requery

which will requery the entire form

[isladogs]

Use Me.Requery. It should update everything on your form.

[www]

right, but will it requery the date boxes which are on the same form?

[CJ_London]

yes - but since these are manually completed, they won't change

tip - enter the code as suggested, comment out your existing code and just try it.

[www]

Thanks,

I tried the code but now nothing is updating:

Private Sub txt_str_dte_AfterUpdate()
Me.Requery
End Sub


Should I use something other than After Update?

[www]

me.recalc worked

Thanks