Printing Form of Selected Recordset

[JonC]

I have a database where the user selects recordsets via a form with 2
levels of nested subforms. The recordsets are filtered using a series
of linked combo boxes and I would like to be able to print the slected
recordset from the form. The problem is that when I try and print the
form the combo boxes reset to their default values and so only the
first recordset is displayed. Is there any way around this? I have
tried opening a report of the selected recordset but the fact that I
have 2 nested subforms seems to be throwing up too many problems for an
access novice such as myself. If anyone can offer any help or
suggestions I would be eternally grateful.

[Phil Stanton]

Try creating a query as the source of the report.
The query would contain criteria like Something =
forms!Mainform!Subform.form!FieldName

Phil

"JonC" <jo***********@hotmail.comwrote in message
news:11**********************@q2g2000cwa.googlegro ups.com...

>I have a database where the user selects recordsets via a form with 2
levels of nested subforms. The recordsets are filtered using a series
of linked combo boxes and I would like to be able to print the slected
recordset from the form. The problem is that when I try and print the
form the combo boxes reset to their default values and so only the
first recordset is displayed. Is there any way around this? I have
tried opening a report of the selected recordset but the fact that I
have 2 nested subforms seems to be throwing up too many problems for an
access novice such as myself. If anyone can offer any help or
suggestions I would be eternally grateful.

[JonC]

Thanks for that Phil, I'll give it a go. I'm new to access and I've not
had much to do with queries yet.
Phil Stanton wrote:

Try creating a query as the source of the report.
The query would contain criteria like Something =
forms!Mainform!Subform.form!FieldName

Phil

"JonC" <jo***********@hotmail.comwrote in message
news:11**********************@q2g2000cwa.googlegro ups.com...

I have a database where the user selects recordsets via a form with 2
levels of nested subforms. The recordsets are filtered using a series
of linked combo boxes and I would like to be able to print the slected
recordset from the form. The problem is that when I try and print the
form the combo boxes reset to their default values and so only the
first recordset is displayed. Is there any way around this? I have
tried opening a report of the selected recordset but the fact that I
have 2 nested subforms seems to be throwing up too many problems for an
access novice such as myself. If anyone can offer any help or
suggestions I would be eternally grateful.