Create combo box values on sub-form from values in another 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.

 

[JerryDennison]

I'm going to assume you're using the primary key of the record for the names from the names table. In the rowsource query set the criteria for the name's primary key field to the name field of the other subform.

=Forms!MainFormName!SubFormName!NameField

 

[Guest_imported]

Thanks. I'll give it a shot this way. I've been traveling.