Re: Copy Record With VBA (Access 2000)

The reason I need to do it is to allow the user to use an existing record as
the starting point for the new record. For example, if you need to create a
new record with 50 fields, and 40 of them are the same as an existing record,
allow the user to copy all of the data to a new record, increment the index #
(primary key), and load the new record into the form so the user can modify
the 10 fields that are unique. The current method is to go back and forth
with Ctrl-C/Ctrl-V to copy the 40 common fields to the new record. If you do
know an easy way to do this, I would appreciate your help!

Thanks!

"Tim Ferguson" wrote:

> =?Utf-8?B?V0NS?= <WCR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> news:F1D2C91C-3531-4C6F-9B3C-852EFD261E1F@xxxxxxxxxxxxx:
>
> > I want to create a new record by clicking on a button in a form. The
> > record needs to copy the data from the form's current record in all
> > fields but one (a unique index field). The button wizard has a copy
> > record option, but it doesn't seem to work.
> >
>
> Yes, it is quite easy to do and there are a number of ways to achieve it --
> but the more important question is why you want to do it. There is hardly
> ever any valid reason to put the same data into two records in a table
> (that was going to be 'never any reason', but there is always a first
> time). Rather than having repeating records, you should probably be
> normalising the design.
>
> All the best
>
>
> Tim F
>
>
.