troubleshooting Question

Command to add x number of records with the same information as the current one

Avatar of esbyrt
esbyrtFlag for Canada asked on
Microsoft Access
17 Comments1 Solution364 ViewsLast Modified:
Hi folks.  I have a database that tracks lab samples and the tests performed on them.  My original design adds each sample in a continuous form with a command that opens another continuous form to select the tests to be performed on each sample.  My users are finding they are receiving a hundred samples at a time from the same customer, all to be tested for the same things.  Entering all the samples and test codes individually is becoming time consuming.  Is there a way, maybe a command button that they can click, that would take the field data from the current record, create x number of new records, and paste the field data into the new records?
I'm thinking an append query should do it but I'm not quite sure how to implement it.  In my  sample form this would be just text information regarding the sample source.  But in the continuous form for selecting the tests to run the number of tests and content will vary.
I've included a couple screen shots to make things clearer if I haven't explained well. Thanks!
the sample entry screentest selection screem
Join our community to see this answer!
Unlock 1 Answer and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros