Focus in a Form

[f0rg3tfu1]

Hello all,

Quick access question....

I have a form in Access 2003. On the bottom I have a series of tabbed panels.

I want to say that if this particular field is equal to "KPI" that the SECOND tab will be in focus... and if not then the other tab will be in focus.

Any idea how to do this?

Thanks everyone!

 

[mintjulep]

Where does "KPI" come from?

 

[fumei]

And what are you thinking is the event that would check to see if it is "KPI"?

Gerry
My paintings and sculpture

 

[ycim]

Can you just check the field value in the "current" event, and then set the focus to the 2nd page if the field is "KPI

 

[fumei]

Which is my question - what is firing that will do the check? Setting the focus by the value of the field is not the issue - it is strictly a logic statement. IF feld = KPI THEN SetFocus blah. But what is firing that logic statement?

A commandbutton?
A _Change event?
An _Update event?

Gerry
My paintings and sculpture