Connecting Tech Pros Worldwide Help | Site Map

refresh or requery form display on field change

Birderman
Guest
 
Posts: n/a
#1: Jul 24 '06
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
birderman@hotmail.com



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

bsn
Guest
 
Posts: n/a
#2: Jul 24 '06

re: refresh or requery form display on field change



"Birderman" <birdermanremovethis@hotmail.comskrev i en meddelelse
news:44c4dc87$0$23885$88260bb3@free.teranews.com.. .
Quote:
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


Closed Thread