How to reference a value on a subform that is based on a query

C

ChadB

Hi,

I have developed a query which will work very well for my user interface.
The query has a subdatasheet which is another query.

Example query output (qryGrpMem)
GroupName GroupID Count
+ Num1 1 3
+ Num2 2 2
- Num3 3 2
Memebers MemberID
Dan 1
Sally 5
+ Num4 4 6

I have placed the query on a form as a subform control. Control name is
child0
I need to be able to reference values in both the top level query and its
subdatasheet. I have no problem referencing the top level query, but can not
find out how to reference anything below it

My subform Property (source object) = query.qryGrpMem - the above query
with a subdatasheet

If I want to retrieve the selected row value of the top level of the query I
will use

Me.child0.controls("GroupName").value

child0 was the name of the subformControl

I can not figure out how to reference the memberID.

I have read many post on referencing a subform that has a subform, but those
methods do not work.

Any Suggestion?
 

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

Referring to control in the active subform 0
subForm on a subForm coding question 2
GrandTotal based on fields in two separate subforms... 5
Selecting series in a chart based on a range and manual inputs 0
Subform not refreshing 2
Subform, combo box, parameter query? 3
Reference to calc field on sister subform? 1
Save value from subform to table 1

Top