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

[SimonT]

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

Post by Albert D. Kallal
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