how can i access many table to one form

[T_777]

i hope u can understand me ( i dont speak english very well ,but i can understand u)

i have many table without relation, and i dont want to make a relation bucause there isn't need to

all the tables are the same ( store student data for each year)

the tabel fields are
student name , art , geography , history , math , ,,,

i want to make one form access to these table by chooseing them in listbox which store the name of table( t_1999 , t_2000 , t_2001 ,,,,) and click a button to change the recordsource

now i do this manually ( goto disign view and change the recordsource of the form and Data)

is ther a way to do this?


thank u for help

[Tanis]

You need to create a Union Query from your students tables. Run a Make Table query based on the Union Query, then base a form on the Make table query. By the way, you should not have the same data in different tables. There is no reason why the data cannot go in one table! Makes it far easier for queries.