Continuous Form

[nyzja]

Hi! I have a form with a combo box and 3 tabs associated with the values in the combo box. Depending on the data selected for the combo box, I need to hide or show the appropriate tab to show sub categories. It works on Single Form view, but I need to use it for a Continuous Form view. So the problem is when I pick out a category from the combo box for the first record, all the tabs for all the other records are also changing.

Is it possible to tie the objects to each record?

Please advise. Thanks!

 

[MajP]

Not possible as AFIK. When you use an unbound control there really is only one control and all of the rest are just paint on the screen. Same thing if you put an unbound check box on a continous form. If you click in one record they all get a check or uncheck. Often you can use conditional formatting to do things like make a certain text box change a color based on the value in the record.

Not exactly what you are looking for.
You could put the tab control at the bottom of the page in a footer and use the on current of the form and after update of the combo to set the tabs to the correct choice. So as you click in a record or change the combo you see the appropriate sub choices for that record. Maybe a more intuitive way would be to put a continous subform on a main form. Then to the right of the Subform you could put something that shows the sub categories and changes based on the current record.