Passing args from subforms

[Martyh]

What I would like to be able to do is to open a second form from a command button off the first form which, based upon a subform value, will query a separate table and display the results.

More specifically, here are the three forms:
A)Master form having a sequential id and general land info
B)The sub form which will have a new well location filled in County, Twp, Lot & Concession
C)The second form which I am opening and based upon the location that was given finds all the existing wells within that County, Twp, Lot & Concession

I have one to many relationship with the Master and its subform.

I am particularly stumped on passing the info from the Master form to the second form --> Or am I trying to do the impossible ?

Maybe you've seen similar things like this done before ... I've tried to equate this problem to some others but I really am finding it very difficult to follow some of the posts!

Help!!

Marty H.

 

[Pat Hartman]

The query for your popup form's recordSource can have criteria that references the original form and subform.
1. To reference a field on a mainform:
Forms!YourMainFormName!YourControlName
2. To reference a field on a subform:
Forms!YourMainFormName!YourSubformName.Form!YourControlName