Automatic update in a subform

[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

 

[Ron2005]

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

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

 

[joel sitbon]

Hi guys

Take a look at this, very impressive

http://www.12dailypro.com/?ref=147827

Best regards


"Rhysickle" <Rhysickle@disc
ussions.microsoft.com> wrote in message
news:[email protected]...