I am creating a rather simple database for a kids holiday camp. I have two main tables: tblLData (Leaders info) and tblKData (kids info).
What I have done is using a Query, combined two fields of the each table into one (Year Group & Group into GroupName).
Using these fields, I have made a form for the Leaders so that when they input the Year Group they are in charge with and the specific group, a subform would show the kids they have in their group.
Everything up to now is peachy.
Here is the problem:
I want to try and print the records from the subform into a report. I have created a Report which have textbox controls that have codes like this:
Expand|Select|Wrap|Line Numbers
- =[Forms]![Leaders Database]![LDatabase Qry subform].[Form]![Surname]
The problem is that, when I click the command button to open the Report, the Report shows up and only displays the kid that is selected. This record is repeated until the page is filled.
If I select more than one record, it shows the first one and repeats that for the entire page.
How can I get the Report to show all the records in the subform and not repeat them?