query delaying updates

[wshm]

i have just few update queries that runs afterevent of a command buttong.

ie. docmd.OpenQuery "qry_Total"
docmd.OpenQuery "qry_Expenditures"
docmd.OpenQuery "qry_Balance"

for some reason, queries are not updating the current
values on the form. At first, I thought the queries
are not working properly but it's actually working.
Calculations are all correct but it updates everything
but the record i just entered on the form.
It updates the previous record i entered from the form but
won't update the current record until i run the aftervent again.

any idea what might be causing this problem?

 

[Crowley16]

is this a bound form you're using?

have you considered putting a requery behind the updates?

--------------------
Procrastinate Now!

 

[wshm]

requery? tables? and yes it's a bound form.