Executing a specific sub when switching between records on a form

[mahi]

I have a columnar form that displays data from an Access table. It also
displays some checkboxes depending on the data in the current shown
record.

When I switch between records using the navigation buttons or the
mousewheel, the data retrieved from the database is properly updated,
but the checkboxes are not.

My guess is that I need to execute the sub that contains the code for
these checkboxes whenever the records are switched.

But... Where do I call the checkbox sub to accomplish this? I looked
through all actions that are available for the form, but none seemed to
work.

Anyone can point me in the right direction?

 

[DebbieG]

My guess would be in Form_Current. What is your code for displaying the checkboxes?

Debbie


|I have a columnar form that displays data from an Access table. It also
| displays some checkboxes depending on the data in the current shown
| record.
|
| When I switch between records using the navigation buttons or the
| mousewheel, the data retrieved from the database is properly updated,
| but the checkboxes are not.
|
| My guess is that I need to execute the sub that contains the code for
| these checkboxes whenever the records are switched.
|
| But... Where do I call the checkbox sub to accomplish this? I looked
| through all actions that are available for the form, but none seemed to
| work.
|
| Anyone can point me in the right direction?
|
| --
| mahi

 

[mahi]

My guess would be in Form_Current. What is your code for displaying the checkboxes?

The code is rather complex, but when put in Form_Current it works. I'm
not sure why it didn't work when I tried earlier - maybe I just forgot
that action.

Thanks a lot!