Select Record in query, save as New Record then edit New Record

Select Record in query, save as New Record then edit New Record

Post by c3ByZWFkc2 » Thu, 28 Jan 2010 06:03:03

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
this beginner.

Select Record in query, save as New Record then edit New Record

Post by Jeff Boyc » Thu, 28 Jan 2010 06:41:49


It all starts with the data ... "how" depends on "what" ... and you've been
describing the forms, not the underlying tables.

It bears noting that your previous experience with Excel may very well work
against you! The way you'd create a new record in Excel (copy an existing
one and make a few changes) can be done in Access, but it's not very good
use of the tool (think trying to drive nails with a chainsaw).

If you want to get the best use of the relationally-oriented
features/functions Access offers, you can't feed it 'sheet data.

Please post a description of your tables and how they are related.

If "relational" and "normalization" are not part of your vocabulary, plan on
spending some time coming up to speed on them to get better use of Access.

Good luck!


Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endor *** t thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer

"spreadsheetlady" < XXXX@XXXXX.COM > wrote in