Update main form with data from a sub form

G

Guest

I need help with the code to update data on the main form when updating
data in a sub form
 
P

Pat Hartman\(MVP\)

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
 
P

Pat Hartman\(MVP\)

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.
 

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 Sub form opens before the main form in MS Access 0
How to make a sum of a sub-form on the main form 2
Sub-Form data entry 9
Update subform with combobox change on main form 1
Access Passing data from a form to another form! 0
Access Form Refresh 1
How to UPDATE records using a sub-form 1
Main Form and two Subforms 2

Top