Add tabs to a subform containing a tab control..?

[alex]

Hi,

I'm developing an Access project that users will use daily to fill reports that they used to fill by hands. Basically, there are 10 different reports that contain 90% of the same information (date, name, temperature, etc), plus 10% specific to the kind of activity.

Since the application will be used on a small device, I've used a tab control to separate the information in different tabs: administration, notes, etc.

Now I'm wondering how I can add that 10% specific information to my existing tabs...I see 2 solutions so far:

1. Copy my form 10 times for my 10 reports, and add a different tab to each new form. Problem: If I make a change in one of the "base" tab, I have to make the change 10 times.

2. Add 10 new tabs to my existing form, and play with the visible property according to which report is being filled. Problem: it doesn't scale...if the client ask me to add 20 new reports, I'll be stuck with a tab control containing more than 30 tabs..

Any idea of a better solution? I was thinking about dynamically adding a new tab to the control depending on the report being filled, but I don't know if it's possible and if it would make the application really complicated.

Thanks!

 

[Uncle Gizmo]

>>>1. Copy my form 10 times for my 10 reports, and add a different tab to each new form. Problem: If I make a change in one of the "base" tab, I have to make the change 10 times.<<<

You can avoid the problem you have identified above: >>>make the change 10 times.<<< by placing on each tab a subform window, and then have that subform window display a copy of your master form, but with a different record source for each copy. Now you will have only one master sub form which you can change when necessary.

More Info Here:

Time Management Matrix Demo of the principle Here:

 

[alex]

Exactly what I was looking for! Thanks!