Automatic update in a subform

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

Guest

Hello,

I have a subform (Trials) within a form (Schools)

In schools I have a field [contact], and the same in "Trials". in trials i
also have a field [Trial], which is a combo box.

I want the form to automatically pull the [contact] from schools into the
[contact] in trials whenever [Trial] is updated.

I don't really know any basic, and very little SQL, so if anyone can hel me
out with a complte event procedure that'd be a gret help.

Thanks

Rhys
 
In the afterupdate event of the Trial field on the Trials subform

me.contact = forms![Schools]![Contact]
 
Back
Top