Button to copy previous in form?

[Jorge]

Hi

Is there an easy way in order to copy/duplicate the information within a
form?

i.e.
I have a user that places in a name, date, address, phone... etc.
The form also automatically assigns a record# (primary key).
I'd like to have a button on the form so that when it is pressed the
previous information appears albeit with a new rec#.

Is there an easy way to do this?

Thank-you
Jorge

 

[Roger Carlson]

Yes there is.

In the button wizard, in the "Record Operations" section there is a
"Duplicate Record" action. Follow the wizard screens and it will make it
for you.

HOWEVER, YOU SHOULD NOT DO THIS!

In a properly designed database, information is stored only once. What you
*should* do is have a table for the demographic information (name, address,
etc) and a separate table with all the data that varies for each person.
Let's assume this is a Customer/Order situation. You would have a customer
table and an Orders table. Each customer can have one or more orders, so it
is a one-to-many relationship. You create this relationship (and you should
do this in the Relationship Window) by adding the primary key of Customer
(CustID) into the Orders table (as a long integer). Then create the
relationship something like this:

Customer Orders
----------- ----------
CustID ------| OrderID
CustName |----<CustID
Addr (etc) Quantity(etc)

In a form, you would create a form/subform with the form based on Customer
and the subform based on Orders. Link the form and subform on CustID and
you don't have to worry about duplicated values.

On my website (see sig below) is a Tutorials section that has more examples
and explanations of how to design a database.

 

[Jorge]

Might I inquire....?
Is there a button wizard within Access 2000?
If so where? I looked through help and it wasn't much HELP..

So HELP

Jorge

 

[Roger Carlson]

On the ToolBox bar (the one that has all of the standard controls) is a
wizard button. Click it down and when you create a button or combo or
listbox, it will walk you through a wizard.

 

[Jorge]

Learn something new each day!

Thank-you

On the ToolBox bar (the one that has all of the standard controls) is a
wizard button. Click it down and when you create a button or combo or
listbox, it will walk you through a wizard.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

within