Tab Controls and subforms

[Guest]

I have a form with 5 tabs - one of the tabs has a subform holding financial
info about jobs. I am wanting to ask the user if they want to add standard
financial information to the job if no data has been entered when they click
on the finance tab. There is a field on the form called finaceId and I can
check if this value is null. If I place code in the subforms load or current
event these seem to be triggered even if the finance tab is not selected. I
also tried the activate event and page click event with no luck. I am now
pretty stuck for ideas
Any help gratefully recieved

 

[Rick Brandt]

I have a form with 5 tabs - one of the tabs has a subform holding
financial info about jobs. I am wanting to ask the user if they want
to add standard financial information to the job if no data has been
entered when they click on the finance tab. There is a field on the
form called finaceId and I can check if this value is null. If I
place code in the subforms load or current event these seem to be
triggered even if the finance tab is not selected. I also tried the
activate event and page click event with no luck. I am now pretty
stuck for ideas
Any help gratefully recieved

Use the Change event of the TabControl (not of a page). In your code test the
Value property of the TabControl to determine which page was selected and only
run the rest of your code when the desired page is chosen.

 

[Baz]

Use the Change event of the tab control.

 

[Guest]

Thank you both that works fine

Use the Change event of the tab control.