A custom action in a report that partly duplicates a previously entered record and opens it in a new form that the previous record was created in, additionally populating a reference id field of the old records autonumber.

I have created custom actions in other reports, its really the script to duplicate a previously entered (Into Form A) record (certain fields) and open Form A with some of a previous records data pre populated. Also a way to copy a autonumber field and populate a reference field in the new record.

Simplified Example:

FORM A	Record Report	FORM A
Name: John	Custom Action button	Name: John
Customer: John's Repair	to launch script	Customer: John's Repair
Email: john@johnsrepairs.com		Email: john@johnsrepairs.com
Phone: 123-456-7890		Phone: 123-456-7890
Notes: John needs help with his website		Notes:
Autonumber: 1		Autonumber: 2
ID Reference:		ID Reference: 1

Any assistance would be greatly appreciated.

Thank you