Force text box requery

[ellenr]

Is there a way to trigger requery of a dlookup text box value when a popup has changed the underlying table value?

I have a similar situation when form A displays a couple of dcount text values. A button on form A opens Form B where underlying data may be changed. In that instance I have tried to requery on got focus Form A after Form B closes, but it doesn't update.

 

[arnelgp]

On afterUpdate event of pop up, recalc form A.

Pruvate sub form_afterupdate()
Forms!formA.recalc
End sub

 

[A S MANN]

You can set the [TempVars]![PopUp] as after upupdate property of pop up. Create the query filter on [TempVars]![PopUp]. That way when pop up changes [TempVars]![PopUp] changes and query data modify and hence form update.