Which Event do I have to use?

[easytimes.ch]

Tables used:
- WeekOfYear-(Fields: WY_id, WY_Year, WY_WeekNr)-
- User -(Fields: User_id, User_Name, User_Firstname)-
- WorkReport-(Fields: WR_id, WR_User_id, WR_WY_id, WR_Description)-

In the Form 'frmWorkReport' I select a 'WeekOfYear', a 'User' and add
Description.

In a Label-Field in the Head of the Form I would like to show th
details of the selected User.

I use the 'AfterUpdate'-Event (of the Drop Down Control where I choos
the User) and set the corresponding text of the Lable Field in VBA.

--> so far so good...

Problem:

When I step trough the Records without changing data, I need an even
to update the label. Form_Query and Form_DataChange seem to be th
wrong events.... *Which events are triggered, when a user navigate
from one record to the next?*`

Thank you for your help

 

[Graham R Seach]

Use the form's Current event.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia

 

[easytimes.ch]

ups, it's that easy.... works now just fine.

thanks a lot
and