Loading record from a subform

G

Greg

On my main form I also have a subform and after updating record I am sending
an email. After sending an email I would like to load first record from a
subform into main form. Any ideas how I can accomplish this?
 
A

Arvin Meyer [MVP]

Subforms generally exist for the purpose of editiing or displaying the many
side of a 1 to many relationship. They should never be a detail of the main
form record or they will cause a locking conflict. Only one person or
process can edit a record at a time. You might open another form to that
record, and close the calling form. A command button with code like:

DoCmd.OpenForm "NewForm" ,,,"ID =" & Me.txtID
DoCmd.Close acForm, Me.Name
 
Top