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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Syntax for subform record source change 6
Highlight rows in a subform datasheet view 0
Nav Buttons Don't Work 1
Main Form with Subforms 5
Filter Table in Subform Control according to TextBox control value 1
Synchronising subform from another subform 2
subform total behaving strangely 2
Forms & Subforms 2

Top