Printing Form of Selected Recordset

  • Thread starter Thread starter JonC
  • Start date Start date
J

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.
 
Try creating a query as the source of the report.
The query would contain criteria like Something =
forms!Mainform!Subform.form!FieldName

Phil
 
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.
 
Back
Top