Fresh Access Form Data from SQL BE

[SimonT]

Hi Guys,

Hopefully someone will have a simple answer to this one? I have a from that
runs an price update and after the update has done the form data needs to be
refreshed.

Previously before the using SQL backend the form refreshed fine with:

[Forms]![frmPriceModify]![price].Requery

However this no longer works, can anyone suggest what I need to do to
refresh now?

Thanks
Si

[Albert D. Kallal]

Hum, I would try this code first (it simply forces a disk write):

me.Dirty = false

If the above don't work, then could try

me.Refresh

Place/test ONE of the above before your control re-query command. in fact,
if one of the above fixes this, you might then be able to remove your
.Requery on the contorl....

Note that normally when setting me.dirty = false we check if the reocrd is
dirty, but since you talking about after update event, then that even will
not fire unless the form is dirty anyway...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOO...@msn.com

[SimonT]

Cheers Albert, the me.Refresh worked fine
Kind regards
Si

"Albert D. Kallal" <PleaseNOOO...@msn.com> wrote in message
news:%23C9iWzz...@TK2MSFTNGP05.phx.gbl...