Updating Subform to Requery Second Subform

[skoutr1]

Looking for VBA to do the following (some names have been changed to protect the innocent):

I have a form (frmLog) based on a table (tblLog) with 2 subforms (sfrmOne and sfrmTwo). sfrmOne Record Source is a table (tblOne) and sfrmTwo Record Source is a query (qryTwo). Forms and subforms are linked via a date field (dteLog).

When a record is updated or added in sfrmOne, I want sfrmTwo to requery/recalculate to update calculated values from sfrmOne.

If I navigate away from the edited record in frmLog, and then return, the updated calculations are displayed. I would like the calculation to be "live" as records are changed.

 

[dhookom]

You might want to check out Refer to Form and Subform properties and controls to get the syntax correct.

Duane
Hook'D on Access
MS Access MVP

 

[skoutr1]

PROBLEM SOLVED!

Placed the following for the OnExit Event for sfrmOne

Forms!frmLog.Refresh