Refresh form data

[burrina]

I have a main form that stays open all the time. Sometimes I change the data on other forms that are reflected on this main form and need it to display the latest data when it has the focus again.
What event should I use and code to do this?

RESOLVED:
Thanks,

[HansV]

You could use the On Got Focus event of the form. If you have merely modified existing records, you can use the Refresh method; if you may have added or removed records, use the Requery method. For example:

Code: Select all

Private Sub Form_GotFocus()
    Me.Refresh
End Sub

Remark: because the Requery method loads the record source of the form again from scratch, the form will jump to the first record by default.

[burrina]

The form is unbound, only some data on it uses either an expression or DLookup.

[HansV]

In that case, you can use Me.Recalc instead of Me.Refresh.

[burrina]

Thanks