Notes Popup

  • Thread starter Thread starter NormanP via AccessMonster.com
  • Start date Start date
N

NormanP via AccessMonster.com

I have a main form that has a button to bring up the notes subform for a
record. The trackingno is autonum. How do I reference and populate the
trackingno from the mainform to my subform? The childlinking works for
existing notes, but not for new notes.

I have a separate notes table and a main table.

Thanks,
NormanP
 
You can add code in the BeforeUpdate event of the notes subform to set the
value of the "trackingno" to whatever it is on the mainform. Alternatively
you can add a default value to the trackingno field on the subform.

Me.trackingno = forms!mainform!trackingno

HTH
Diana Criscione
 
Back
Top