Choose the table to enter records

[hr833]

I was wondering whether i could allow the user to choose the table that the entries are to be inserted into.

I'm using a SQl command to insert the new records into a table that consists of other records of the same year.

I realise that the company would have many other year od records and after hearing how access may cork up when the number of records get too much like 100,000? I tot that maybe seperating the records into year would be better.

So how can the user choose the table tat the records are to be transfer into. Like a radio button or a combo box..

Please and Thank you!

[damonreid]

You could build a form and copy it for each year. Then change the Record Source of the form to a different table (with the same fields).

The simply allow the correct form to open on some condition (select a year from a drop down list, if = 2007 open form a, if 2008 open form b ect...)

It is a bit clumbersome though.