Combo Boxes and subforms

[Guest]

I have a form based on a master table and a subform based on a detail table. The form has a combo box which works well to filter the records I wish and the underlying detail records do appear.

However I require to enable the user to further filter the information in the subform by year and month and am using two combo boxes to achieve this

I also have a filter which looks something like thi

GLFeeder!Year = Forms!Fornamename!subformname!Yearcombo and GLFeeder!Period = Forms!Fornamename!subformname!Periodcomb

where GL Feeder is the name of the table

I am being prompted for GLFeeder!Year and GLFeeder!Period, which are being treated like Parameters. Is this because the main form (based on a different table) has the focus.

 

[Roger Carlson]

On my website is a small sample database called "SubformReference.mdb" which
demonstrates how to reference controls on subforms and subsubforms, plus a
whole lot more.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

I have a form based on a master table and a subform based on a detail

table. The form has a combo box which works well to filter the records I
wish and the underlying detail records do appear.

However I require to enable the user to further filter the information in

the subform by year and month and am using two combo boxes to achieve this.

I also have a filter which looks something like this

GLFeeder!Year = Forms!Fornamename!subformname!Yearcombo and

GLFeeder!Period = Forms!Fornamename!subformname!Periodcombo

where GL Feeder is the name of the table.

I am being prompted for GLFeeder!Year and GLFeeder!Period, which are being

treated like Parameters. Is this because the main form (based on a
different table) has the focus.

 

[Guest]

Thank you. I have looked at the website and it will
doubtless be very useful to me in my work. I have of
course made a donation.


However the referencing of the subform controld does not
seem to be the problem. The filter table criteria seems
to prompt for parameters which populates the controls
correctly.

Difficult to explain perhaps but if there is specific
info i can give. Please tell me

-----Original Message-----
On my website is a small sample database

called "SubformReference.mdb" which