Access 2000 - Determining When A Record Changes For A Form

[gcaughill]

Hello,

I have a form with numerous tabs on it. On one of the tabs is a
subform that lets the user select a program from a drop down list.
Depending on which program(s) are selected more tabs could be opened up
to enter new information.

I would like to determine when the current record changes so I can
lookup which tabs should be hidden and which ones should be shown.

I tried to do that by looking when a field (id) changed but it did not
work since it was a calculated field.

Is there another way to do this?

Thanks,

 

[Allen Browne]

The Current event of the form fires when you change record.

 

[Guest]

Use the Current Event of the subform where you select a program.