I have a Select Query with a Split Form attached to it. Access 2007.
I print out single page Lab Test Certificates that are sent out to Customers.
This is done through a Report also attached to the same Query.
When you click on a record visible in the bottom of the Split Form, it shows
in the fields (test boxes) in the upper portion of the form. The report is
created using this active record that is showing in the form.
Sometimes the same Certificate (record) is used again and only certain
fields need changing to create a new one. I would like to keep the old
record with it's original ID number.
Using a Command Button. Would it be possible to copy the selected query
record in the form, then paste it into the next (new) blank record so it may
be utilized as a new certificate for printing?
This is my very first Database. I've always used Excel, so I have some
experience with V.B. but still a novice. I see you cannot record macros in
Access, and I did not see what I wanted to do in the macro builder.
Thank you for your time, and thanx in advance if anyone has suggestions for