Copy or generate a form with a tab control

  • Thread starter ragtopcaddy via AccessMonster.com
  • Start date
R

ragtopcaddy via AccessMonster.com

I am setting up a form that will add a tab for each new entry selected in a
combo box.
It opens with an invisible tab control with one tab. When the user makes his
first selection in the combo box, the tab caption is renamed and the control,
containing relevant data, is made visible. When the user selects an
additional entry, a new tab will be added to the tab control. Once the
process is completed and the data generated, it will be exported to an Excel
workbook. Obviously, the next time the process is initiated, it should begin
with a blank form. So I am considering how best to do this.

Code advice for any of the following (along with any other suggestions) that
you find most effective would be appreciated:

1. Keep a copy of the form as a template with 1 tab on an invisible tab
control in the back end and write some code to "Get external data" and copy
the form anew to the user front end.

2. Delete all but the 1st tab and set the form's tab control to visible -
false.

3. Delete the tab control and add it anew with one tab and set it to visible
= false.

BTW, what's the limit on tabs in a control? If that limit is met, perhaps I
should replace the tab control with a continuous subform? In 99% of cases
there will likely be less than 10 entries.

Thanks for your help

Bill R
 
Top