Solved: Field Refresh

[jauner]

I have a form that has several subforms on a tabbed control. The last tab on the control has 2 fields that the control source is based on two functions that add several fields from the rest of the subforms (I did this because of the number of fields being added). Is there a way to refresh these two fields when the tab is clicked on? This way it always contains the freshest data.

Not sure the best way to do this. Or would I be better off to leave the fields unbound and to have a function set the value property of these two fields?

Either way I am not sure which event would take care of this and if there is a way to refresh the fields.

Please help.

[jauner]

Well I found the best way to do this is using a Me.Recalc and to do it on the one field that gets focus on the subform. Works like a charm.