Updates in the Control Box

  • Thread starter Thread starter Simon Lang
  • Start date Start date
S

Simon Lang

I've set up a Dsum function (off a query) in a control box, the function
itself works fine, however it doesn't update automatically unless I go in and
out of form/design views. I'm sure it's something simple I'm missing, if
someone can put their finger on it, it would be greatly appreciated.

Regards
 
Simon,
When any value arguments of the DLookup change, try a Refresh on that
control's AfterUpdate.
Ex. CustCity argument...

DLookup("[XYZ]" , "tblABC" , "CustCity = '" & Me.CustCity & "'"

On the AfterUpdate event of CustCity...
Refresh
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top