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