Open form containing fields of a record

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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!
 
Kevin said:
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.
Click to expand...


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
 
Back
Top