Update main form with data from a sub form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help with the code to update data on the main form when updating
data in a sub form
 
Data from subform records doesn't belong on the mainform.

To do this, you need code in the subform's AfterUpdate event. You can then
use something like:
Me.Parent.SomeField = Me.SomeField
 
Are you really using a subform? Forms that you open with the OpenForm
Method/Action are not subforms. What is the point of saving data from a
subform to the mainform. The mainform can only hold the value for a single
subform record so it hardly makes sense.
 
Back
Top