Force text box requery (1 Viewer)

ellenr

Registered User.
Local time
Yesterday, 23:24
Joined
Apr 15, 2011
Messages
397
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

..forever waiting... waiting for jellybean!
Local time
Today, 11:24
Joined
May 7, 2009
Messages
19,231
On afterUpdate event of pop up, recalc form A.

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

A S MANN

New member
Local time
Today, 08:54
Joined
Oct 18, 2017
Messages
9
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.
 

Users who are viewing this thread

Top Bottom