Make Dcount faster

  • Thread starter Thread starter shiro
  • Start date Start date
S

shiro

Hi All,
I have a textbox in my continuos form with DCount function.
It works,but not excatly like I want.The problem,when we
edit some record,it will not dispaly the correct result till we
re open ( close and then open again) the form.How to make
it works directly after we finish edit some record without
need to exit the form first.
 
shiro said:
Hi All,
I have a textbox in my continuos form with DCount function.
It works,but not excatly like I want.The problem,when we
edit some record,it will not dispaly the correct result till we
re open ( close and then open again) the form.How to make
it works directly after we finish edit some record without
need to exit the form first.
Click to expand...

After saving your changes, you can do a Me.Refresh to get updated data
for the current record.

Or you could requery that TextBox control:

Me!txtTotalPaid.Requery


--
'--------------------------
' John Mishefske
' UtterAccess Editor
' 2007 Microsoft MVP
'--------------------------
 
Back
Top