Hello.

I have a database with many tables and related forms, which have approx 7 fields which are already populated with address information. They are unique by a field called 'Propref' which is a unique property reference number (UPRN)

What I need to be able to do is as follows:

1) The user searches for a record (DONE)
2) Completes the survey (remainding fields) (DONE)

However I would now like a form or button which allows the user to click and copy record.
I.e. they select the record they wish to copy from.
Then select another record which they wish to copy the data to the unpopulated fields.

So they simple access copy button does not work as it copies all fields to a new record.



Any help would be very much appreciated.

Regards
Graeme