Subform and ControlSource!!!!

[legs00]

I have this form (let's call it ACT) where the user enters their criterias which then leads to a subform(Let's call it ACTSUB) that displays various records. The textboxes in ACTSUB are bound to a table (ACTIVITY) except for one textbox.

Now that is my problem!!!!

What I would like to do is retrieve the field INITIAL in the table RESOURCE where its primary key RESOURCEID is equal to the foreign key RESOURCEID of the table ACTIVITY.

Please could anyone tell me if there is any possible way of doing this???!!!!!

Thanks
Legs