Subform Update on Load/Open of Parent form

[ckrows]

Hi guys,

I have a parent form that displays the subform.
The subform query has a link back to the original ID.
I was having issues keepign them in sync, since every parent may not need a subform. So i am trying to create an entry in the subtable whenever the parent is opened. This way it is always in sync and has it ready. VBA is not recognizing the field i want to upodate (tbldashlink) and i get a compile error each time.

Also one more question, since i am using the parent form to execute, does the code go on the parent or subform?

Private Sub Form_AfterUpdate()
Me.tbldashlink.Value = Me.ID
End Sub

[MMcCarthy]

Hi guys,

I have a parent form that displays the subform.
The subform query has a link back to the original ID.
I was having issues keepign them in sync, since every parent may not need a subform. So i am trying to create an entry in the subtable whenever the parent is opened. This way it is always in sync and has it ready. VBA is not recognizing the field i want to upodate (tbldashlink) and i get a compile error each time.

Also one more question, since i am using the parent form to execute, does the code go on the parent or subform?

Private Sub Form_AfterUpdate()
Me.tbldashlink.Value = Me.ID
End Sub

This is not done by VBA. If you have set up your table structures and referential integrity properly this should happen automatically. Have a look at this tutorial.

Database Normalization and Table structures