Subform within a subform - filtering problems

[prairiewind via AccessMonster.com]

I was suggested to use only one table from my project. The reason is that I
want to break it apart by different queries, send the individual tables to
the different field reps, they update the information, send back the tables
and then with a UnionQuery, combine the information into one table. That all
works find, but I can't seem to get my forms to work. What I have is three
levels of information; Field, Meeting, and Person Data. I can have a
Meeting_Subform that works and updates fine when I change between Fields.
But I can't seem to be able to enter a PersonData_Subform within the
Meeting_Subform that would show the people and their contact information that
was at each meeting.

My query that I have the PersonData_Subform based on reads as follows:
SELECT *
FROM tblCombinedData
WHERE (((tblCombinedData.MeetingName)=[Forms]![Meeting subform].[MeetingName])
)
ORDER BY tblCombinedData.PersonOrder;

However, when open the form, it wants me to enter the Parameter "Forms!
Meeting subform.MeetingName".

As far as I understand, a person can have multiple levels of subforms, but
obviously I'm doing something wrong.

Thank you.

 

[ruralguy via AccessMonster.com]

See if this link helps at all: http://www.mvps.org/access/forms/frm0031.htm

I was suggested to use only one table from my project. The reason is that I
want to break it apart by different queries, send the individual tables to
the different field reps, they update the information, send back the tables
and then with a UnionQuery, combine the information into one table. That all
works find, but I can't seem to get my forms to work. What I have is three
levels of information; Field, Meeting, and Person Data. I can have a
Meeting_Subform that works and updates fine when I change between Fields.
But I can't seem to be able to enter a PersonData_Subform within the
Meeting_Subform that would show the people and their contact information that
was at each meeting.

My query that I have the PersonData_Subform based on reads as follows:
SELECT *
FROM tblCombinedData
WHERE (((tblCombinedData.MeetingName)=[Forms]![Meeting subform].[MeetingName])
)
ORDER BY tblCombinedData.PersonOrder;

However, when open the form, it wants me to enter the Parameter "Forms!
Meeting subform.MeetingName".

As far as I understand, a person can have multiple levels of subforms, but
obviously I'm doing something wrong.

Thank you.

 

[prairiewind via AccessMonster.com]

Everything seems to be in order with what the website lined out. Thanks for
the suggestion/help, but will need some more!

See if this link helps at all: http://www.mvps.org/access/forms/frm0031.htm

I was suggested to use only one table from my project. The reason is that I
want to break it apart by different queries, send the individual tables to

[quoted text clipped - 21 lines]

Thank you.

 

[ruralguy via AccessMonster.com]

A SubForm is not directly available through the Forms collection. You need
to go through the MainForm to reference the SubForm.
Forms!MainForm!SubFormControl.Form!ControlNameOnTheSubForm

Everything seems to be in order with what the website lined out. Thanks for
the suggestion/help, but will need some more!

See if this link helps at all: http://www.mvps.org/access/forms/frm0031.htm

[quoted text clipped - 3 lines]

 

[prairiewind via AccessMonster.com]

Thanks. I've made a hidden TxtBox in main form that is populated with the
MeetingName in the subform. I've then used that txtBox as the filter
criteria in the query that supplies the People Information. I only need to
work on the ReQuery part of it. Thanks for all your help.

A SubForm is not directly available through the Forms collection. You need
to go through the MainForm to reference the SubForm.
Forms!MainForm!SubFormControl.Form!ControlNameOnTheSubForm

Everything seems to be in order with what the website lined out. Thanks for
the suggestion/help, but will need some more!

[quoted text clipped - 4 lines]

 

[ruralguy via AccessMonster.com]

You're very welcome.

Thanks. I've made a hidden TxtBox in main form that is populated with the
MeetingName in the subform. I've then used that txtBox as the filter
criteria in the query that supplies the People Information. I only need to
work on the ReQuery part of it. Thanks for all your help.

A SubForm is not directly available through the Forms collection. You need
to go through the MainForm to reference the SubForm.

[quoted text clipped - 5 lines]

 

[prairiewind via AccessMonster.com]

I've gotten the forms to come out right, but being they are based off a query
and not a table, I can't update the parents forms. Is there any way around
this?

The reps should only need to update and add to the child form that whose
Record Source is the table, but I'll need to go in and update and add to the
other information which is where I run into problems.

You're very welcome.

Thanks. I've made a hidden TxtBox in main form that is populated with the
MeetingName in the subform. I've then used that txtBox as the filter

[quoted text clipped - 6 lines]

 

[ruralguy via AccessMonster.com]

There is nothing about a query that makes it inherently nonupdateable. If you
key in troubleshoot queries into the Access Help system (not VBA) there are
explainations as to how this can happen.

Here's another link on the topic.
Why is my query read-only? http://allenbrowne.com/ser-61.html

I've gotten the forms to come out right, but being they are based off a query
and not a table, I can't update the parents forms. Is there any way around
this?

The reps should only need to update and add to the child form that whose
Record Source is the table, but I'll need to go in and update and add to the
other information which is where I run into problems.

You're very welcome.

[quoted text clipped - 3 lines]

 

[prairiewind via AccessMonster.com]

Thanks. I've assigned my Meeting subquery to only show unique records, since
otherwise it shows for each person who attended the meeting, not just once
per meeting. Looks like I'm at a deadend for now and will persue a different
avenue. Thanks for your patience and help.

 

[ruralguy via AccessMonster.com]

Let us know if we can help further. Have fun.

Thanks. I've assigned my Meeting subquery to only show unique records, since
otherwise it shows for each person who attended the meeting, not just once
per meeting. Looks like I'm at a deadend for now and will persue a different
avenue. Thanks for your patience and help.