Need combo box values created from another sub-form in a sub-form.

[Guest_imported]

I have a form that has several subforms. One of the sub-forms (say sub-form1) creates a series of records ( individuals - field trial table) related to the main form (Field Trial Table). In another sub-form Field-Trial Activities (sub-form 2) on the main form I need to allow only the entry of an individual that has been entered into the previous (sub-form1) into a combo box for each record in Sub-Form 2).

Basically, for each record in the second subform I only want to allow the selection for the individual (drop down list box in the record) to be from the individuals entered in the first sub-form not a selection from an individual table that exists (the first sub-form limits the list to the individuals in the individual table).


I have been able to limit the selection of choices to a single bound field on the main form but have been unable to limit the selection to the values in the sub-form.

Any help would be appreciated.