Multiple query results not populating the report properly

[AndrewsPanda]

I currently have a combo box (combo121) on a form. I select the "Company" which is connected to "Company" in the query via [Forms]![courseinfo].[combo121]



That is working. When I press the "query" button on the form the selected company in the combo box is updated in the query and it updates the report templates.


I also want to use the same system to populate a different report, using the same query. This works a bit differently.

Once the company is selected in the first combo box(combo121). I have other combo boxes which bring up students attached to that company. I have multiple combo boxes because I need select multiple students for the one report.

These students are in fields "First Name" and "Last Name". So in the query I can only have those fields once. I have several links to the several combo boxes under "Last Name" as that is the "bound" selection for the combo box:
[Forms]![courseinfo].[comboname1]
[Forms]![courseinfo].[comboname2]
[Forms]![courseinfo].[comboname3]

Problem I am finding is this is bringing up several lines in the query. So when I try to populate the report with all of the different Students I have selected for the query, it won't work properly because I can only put "First Name" & 'Last Name" fields on the report once.


I can explain further if this is a confusing explanation.

Thank you.

[goodguy]

It is very likely that you have a GROUP BY somewhere wither in your query or in your report. Can you check and confirm?

[AndrewsPanda]

The only GROUPBY I have is in the Row Source of the main combo box "Company" (combo121)

[goodguy]

Attach your work so far.

[AndrewsPanda]

The file is currently 5.21mb so I can't attach it on here. Do you know of any good free file server websites that I can upload it to and provide the link?