Hi Frnds,

             I am having a situation where depending on combo box's content, I have to visible TAB CONTROL's page. I have done it. But the problem is that it is fine at first attempt. But after changing the content of combobox on same page it is not working. Can you please help me on this issue with example code??

Thanks

Prasanta,

From the sound of it you are probably getting a type mismatch, but without knowing what is not working it is almost impossible to tell.

What I think you are saying is:

1. I have a combo box which has a rowsource
2. When I make a selection an action is performed based on the selected item in the combo box
3. It worked with the first type of rowsource
4. It does not work with a new type of rowsource

So, whats the difference between the rowsources?

Give us a bit more info and we can get this one...

Lee

im thinking you need to add code for the "after change" event of the combo, either that or add a button to trigger some code, what event are you using now to trigger the code or is it bound?

Hi Lee,
        I have modified my question. Hope now you can help me.

       I am having a situation where depending on combo box's content, I have to visible TAB CONTROL's page. I have done it. But the problem is that it is fine at first combo selection. But after changing selection of the combobox on same page it is not working. Can you please help me on this issue with example code??

Gigaboy is right... you need to put a requery on the control which you are expecting to change, and put it in the AfterUpdate event... in fact try them out to see which works the way you want it to.

The code you should use would be something like:

me.lstBox.requery

Fairly easy... the lstBox refers to the control!

Lee