access a control in a sub from from another subform

G

Geoff Woods

Hi

I have a form with 2 subforms and the subforms are
related to each other.

Selecting a record in subform 1 updates subform 2
I need the record source of the 2nd subform to only list
records that have an ID that matches a field in the 1st
subform (a popup list).

I cannot work out how to reference the 1st subforms
controls from within the 2nd subform. I am trying to
enter the 1st subforms control value into a criteria in
the 2nd subforms record source.



I hope this is clear.

Regards

Geoff
 
Top