Chris
>From the main form you can reference a control on the subform like this: Me!SubformName.Form!ControlName >From the subform you can reference a control on the main form like this: Me!Parent.ControlName HTH Liveson From: [email protected] [mailto:[email protected]] On Behalf Of Chris Nash Sent: Monday, 03 May, 2010 18:09 To: [email protected] Subject: [ms_access] pass selection from form to a report Hi there I have a form with a subfrom and I want to base a report on the contents of the subfrom or its query based on the selection criteria from the master for so for example if it were children in classroom. I select classroom in the master form the subfrom shows me all the kids in attendance and their parents name and address, I then want to press a button that prints a report of the selected children. Thanks -- Chris Nash 07522 189605 follow me on twitter @cjbnash Wave me on google wave [email protected] <mailto:chris.nashh22%40googlewave.com> [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
