refresh or requery form display on field change

[Birderman]

HI,

Any help would be appreciated.

Using Access 2003

I Have a form with several buttons to drive different events that work.

I want the buttons to be enabled or disabled dependent upon certain entries
within fields on the form.
After Update event I can achive this - but it means I need to move to the
next record and back again to the original record to see any change.

If I use requery to update the from to display the buttons in the revised
enabled/disabled state the form moves to the beginning of the recordset, is
there a way to refresh the form without changing records so that if a field
is updated the buttons are displayed correctly.

TIA
Birderman
bi*******@hotmail.com

--
Posted via a free Usenet account from http://www.teranews.com

[bsn]

"Birderman" <bi*****************@hotmail.comskrev i en meddelelse
news:44***********************@free.teranews.com.. .

HI,

Any help would be appreciated.

Using Access 2003

I Have a form with several buttons to drive different events that work.

I want the buttons to be enabled or disabled dependent upon certain
entries within fields on the form.
After Update event I can achive this - but it means I need to move to the
next record and back again to the original record to see any change.

Try "Me.Refresh" in the form fields After Update event...
Bjarne