By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,062 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,062 IT Pros & Developers. It's quick & easy.

Choose the table to enter records

P: 25
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!
Sep 12 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 114
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.
Sep 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.