Refresh form after update of multiple fields

[Drand]

Hi

I have a continuous form which creates an income budget based on 12 fields - Jan thru Dec.

Each month is totaled in the form footer. The fields can be edited.

Is there a way to refresh the totals after any field is changed rather than having to put code in the after update event of each individual field?

Many thanks

 

[Drand]

Sorry Pat

Bad choice of words in my question. My table is structured exactly as you state.

I am just looking to see if there is a "Universal" refresh option after any field is updated.

Thanks

 

[CJ_London]

you can have a public function in your form module called say refreshAll

Function RefreshAll()

me.requery

end function

then in form design view select all the controls that you want to use the function and on the events tab, after update event (where you would normally see [Event Procedure] put

=refreshAll()

 

[Drand]

Thanks for that. Works perfectly and a lot easier then coding each field!!