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!
private sub cmdAdd_click()
dim j as integer, rs as dao.recordset
for j = 1 to 5