Martyh
Registered User.
- Local time
- Yesterday, 23:02
- Joined
- May 2, 2000
- Messages
- 196
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.

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.
