Hi,
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.
Amy

Amy

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!

Regards

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 endorsement 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
possible/necessary.

"spreadsheetlady" <spreadsheetlady@discussions.microsoft.com> wrote in 
message news:2E254723-3B96-4521-B8C7-455D7AF7B77F@microsoft.com...
> Hi,
> 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.
> Amy
>
>
>