Data versioning

[gmacd]

I have a database that contains a form and a subform
within it. I enter data on the main form which populates
the subform if sepcific criteria is met. I'd like to be
able to double click on a line of data in the subform and
have it autofill the main form for editing. I'd also like
access to assign a new id to this record so I can maintain
versions of my records.

Can anyone help?

Thanks in advance!