For changing colours of the tabs you could add a Tag property to each then use similar code to: https://youtu.be/fe5D4iK0Pvk so all you need to do is add the Tag to any new tabs and itll update all. The function could then be passed the Tag you clicked so it knows which one is active.
Tip: Check for Empty/Null Controls - https://www.599cd.com/tips/access/120720-check-for-blank/ Blog Post: https://www.599cd.com/blog/display-article.asp?ID=723
I was already thinking about something like this. When we start getting more and more tabs they're going to be cumbersome to code. I was going to just prefix all of the names with something which would indicate to the code to adjust their color, for example every one of them would start with "EntitySubform_" and then the name of the tab. It could be passed to a function and all of them could still be located. I've never liked using the Tag property.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.