Updates in the Control Box

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
 
A

Al Campagna

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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated control/combo box 1
Access 2003 Calendar Control 11.0 value update 2
Updating data in a table using a query 2
Access How to remove a non-existent field from a form's Field List 0
Using DSUM to get running total on a filtered form 0
DSum Question 1
DLookup in Text box to show Currency (number field) 9
Query Refrenced to Form control update problem 9

Top