Creating unlimited tabs

[ineedaccesshelp]

First time user and was hoping a I could get some help quickly...I have a form that I am creating that needs to have the ability to created unlimited tabs (that would have the same information) after the first tab (with different information). Essentially, I'd like to program the function like they have in excel where you can create unlimited new worksheets with the same format. Would anyone know how to program this as a VBA into Access? If there is a simpler way to do it, I am open to that too, I just figured that there wasn't. Thanks for your help in advance!

[alansidman]

Please explain why you want this design. It does sound unusual. Perhaps if we understood your project then we could better help you. What will you accomplish having multiple tabs set up the same.

[ineedaccesshelp]

What I want to do is be able to create new tabs based off a format I have created without having to have 100 tabs for each form. For example, there might be a company that only has 3 tabs worth of data while another company might have 50 tabs worth of data. Instead having 50 tabs from the get go, I'd like to make it where new tabs that can be created is optional

[alansidman]

I think that you may be missing the concept of a relational database and are thinking like its a spreadsheet. Your forms are for retrieving data and inputting data. They should not be used in a manner similar to a spreadsheet. Build your tables properly with normalization and you will be able to easily retrieve your data in queries and reports. I urge you to read these two white papers to help you understand.

http://forums.aspfree.com/microsoft-...el-349267.html

http://forums.aspfree.com/microsoft-...es-208217.html

Once you have read these, think about your design and then come back with any questions you have about Access.