Duplication of a record

[Geroge Fulham]

Hi!

I have a form that display some information, and I can
navigate through the records by using the nav-buttons at
the bottom.

Now I want to add a button that makes a copy of current
record into a new record, that I then can edit.

How do I do this in a easy way

I made a macro first, that created a new record, but I
dont find any way to copy data from the record I was at
to the newwly created one.

 

[tina]

well, you can write an Append query, to append the table to itself, setting
the criteria on the Primary Key field to
Forms!OpenFormName!PrimaryKeyField - and making sure to *not* append the
primary key field itself.
then you'll probably have to requery the form to get the newly created
record.

hth

 

[Rolls]

Suggest that you create a form to display the contents of the record you
want, then edit the fields and append a new record to your table. If you
create a record first you can then UPDATE it. Either way you'll have to
write a little VBA code to validate, check for nulls, and save to the table.