Reply to thread

Message: [QUOTE="Geoff Woods, post: 1486993"] 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 [/QUOTE]