List Box of Record Sources

[JoeD]

I would like to add a list box to a form to allow my users to select
different tables in the db that are common in structure, and so
changing the record source so they may work on different projects. Each
project has its own table.

Also I would like to create a button on a Swithboard that would ask the
user the name of a new project and create a new table with that name by
coping the structure of a blank master table, so then that new table
and others will be in the list box.

thank in advance

JoeD

 

[Brendan Reynolds]

Don't do it. A different table for each project is a *very* bad database
design. Use one table, and use queries to select records for specific
projects.

 

[JoeD]

Don't do it. A different table for each project is a *very* bad database
design. Use one table, and use queries to select records for specific
projects.

This is more of a data entry and report builder than a db to store
information for long periods of time, most of the projects once
finished and reports printed, will never be touched again by the users,
unless there is an edit to be made. The users would export the table to
a disk for me to save as a master with the project when it is stored or
turned over the the clients who i would like to have a db with one
large table that the smaller ones could be appended to but not edited.

If you have any ideas

Thanks

JoeD