On form close recalc active form

[Guest]

I have a form "Form1" which has a button. When the button is pressed, a new
form "Form2" opens and allows data to be edited.
I need to recalc a text box on Form1 when Form2 closes. How do I do this?

I can't seem to locate an event on Form1, Form2, or the button that will
trigger a recalc.

Thanks

 

[Reggie]

David, Use the on close event of form 2 to set the focus to your
textbox on form1 and requery it:

Private Sub Form_Close()
Forms!Form1.Form.Text1.SetFocus
Forms!Form1.Form.Text1.Requery
End Sub


Reggie