Open form containing fields of a record

[Kevin]

I wish to double click on a record contained in a subform,
the record's fields would then displayed in another form,
changes would then be applied to selected fields of the
record. How would I go about this?

Thanks in advance!

 

[Marshall Barton]

I wish to double click on a record contained in a subform,
the record's fields would then displayed in another form,
changes would then be applied to selected fields of the
record.

Use the OpenForm method's WhereCondition argument to open
the form with the selected record. If you open the form in
Dialog mode, your code will stop executing until the form is
closed, at which time you can requery the subform:

DoCmd.OpenForm "anotherform", _
WhereCondition:= "Key = " & Me.txtKey, _
WindowMode:= acDialog
Me.Requery