Dum Question?

[Mark Weedon]

Hi,

Excuse my ignorance... i'm sure this should be really simple but i can't
find the event that is called when a user moves to the next record on a
form.

I'm trying to run some code that will turn on or off certain controls
depending on the persons age (each record is a person).

I've tried almost all of them!

any help very cool.

cheers,

/mark

 

[Yumex85]

Hi mark,
actually if u r using the record navigator, theres not really an
event like "on change record". (i was having a problem like this a
month ago). I´ve seen some ways you can control it but i was not that
simple. I would recommend you to make buttons and you make event at On
click of this button, its much easier. Then you can use commands like
DoCmd.GoToRecord , , acNext to go to next record or
DoCmd.GoToRecord , , acPrevious to go to previous, just like a record
navigator.
But sometimes, depending on ur needs, you can work with the event
Before_Update of you age field. If i fill with age 17 for instance,
before the field updates, you can check if u should or not disable
certain fields.



Yumi

 

[BruceM]

Try the Current event.