i am trying to make Point of sale system where each tab will be category for example drinks ,burger etc and each category there will be products. these button i will use as products.

i can create buttons on the form and link on the category but it wont be dynamic for example if new category is created than i have to make manual form and add buttons where as if on the tab if i can make buttons than i can handle easily by adding page....

I want to create button on tab control with VBA from different form. When i click to create button than with vba other form will open in a design view and create button on specific tab page.

example i have four tab pages page1 page2 page3 page4 now i want to create button on page 2

-----------------------------------------------
...