Loading record from a subform

  • Thread starter Thread starter Greg
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Main form/Subform Navigation 0
Subform Data Entry Setting 0
Display "No data" message when subform receives no records from qu 4
Retrieving data from subform 1
Problem with form--subform 5
Continous Forms and preventing a new record being created 2
Limit Subform to Data Entry 1
Use TextBox on the main form to limit SubForm 2

Back
Top