Change focus on Tabs....

[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?

 

[IGPCS]

well you can make and if statement on the after update of that field

if fieldName = "KP1" then
    TabName2.setfocus
else
    Tabname1.Setfocus
end if

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[f0rg3tfu1]

Do I make a module with this code?

 

[IGPCS]

you dont need to make a module just right click on that field clikc properties and in the properties there is a line call AfterUpdate and there you choose from the list [Even Procedure] and then click on button that has ... onit on it will open the VBE in ther you type the code i wrote

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[f0rg3tfu1]

Works like a charm thanks!!!

 

[IGPCS]

your welcome i am really happy for you and myself that i feel usefull

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY