Tab control in form

[chappy68]

I have a tab control in a form with two pages. Page one is the main menu and page two is a search form. When I switch to the search page, I want to run some code to clear any selections from previous searches. I know how to clear the selections with Me.cboName = Null. I tried to enter the code for the search page in the On_Click event but it didn't work.

What am I missing?

 

[CIIIHAN]

Have you tried to use a

MsgBox "test"

command to see if the click event is handled right?

 

[vbaInet]

You need the Change Event of the Tab Control, not the page.

 

[chappy68]

You need the Change Event of the Tab Control, not the page.

Thanks for pushing me in the right direction. I searched the forum and now believe I have my solution. Thanks for the help.

CIIIHAN,
I have not tried the MsgBox to test. I will give that a try.

Thanks for the suggestions.

 

[vbaInet]

No worries chappy

 

[CIIIHAN]

You should try to use MsgBox to debug your code
Then you'll see more quickly where it goes wrong.

good luck!

 

[vbaInet]

You should try to use MsgBox to debug your code

There are a few other debug techniques. Debug.Print is what I would use.

 

[CIIIHAN]

And vbaInet kills two birds with one stone..

Thanks

Debug.Print outputs to the immediate window which can be opened through the editor window select view->immediate window
Msgbox creates a pop-up
right?

 

[vbaInet]

Three birds - breaking the MsgBox character limit too.

 

[CIIIHAN]

You done enjoying your self sir?

Thanks though

 

[vbaInet]

:d .