Printing Reports with combo selection

[Hakutabe]

First of all sorry if its not related to here but the final result is to get to the report so i thought this is the right place
ok so Hello i have 4 Tables which are tblPersonell and tblPersonellRanks
same is with the other 2 tables tblDrivers and tblDriversRanks they both consist of the same things "FirstName","LastName","Rank" and "PersonalNumber" and Ranks got RankID and RankName now Personell are both linked to qryPersonell and Drivers to qryDrivers when i added the qryPersonell i used a combobox to filter "FirstName" and print the document (im still learning Access so it was for testing) now when the last part comes in im lost i linked both Queries to the report and the Firstname becamse "tblPersonell_Firstname" and "tblDrivers_Firstname" i thought that would be could as i could filter them easily and use 2 combo boxes 1 for drivers and 1 for personell but it didnt worked it tripled the data in my personell query and started to give me errors about more than 1 Firstname in the data so my question is how do i fix it? do i need to make a new query and link the 2 other queries to the new one? or is there another way?

i just need 1 combobox to filter Firstname and Lastname of 1 query and another combobox to filter Firstanme and Lastname of the other query and with a button to print the selected data


EDIT: i guess its a little Confusing for people hehe in short how can i use 2 combo boxes to print the selected data (how am i supposed to relate the queries inside the report?

 

[billmeye]

If you want to us comboboxes on a form to filter a report you can either set the report up to use the report property FilterBy and reference your comboboxes, i.e, [Combo1] = 123 And [combo2] = 456. Or, you can use the selections in the comboboxes to restrict what is included in the report recordset by referencing them as criteria in a query. I'm guessing neither of these would mean much to you but if you would attach your DB I could demonstrate for you how to do either of them.

 

[Mihail]

Or, you can use the selections in the comboboxes to restrict what is included in the report recordset by referencing them as criteria in a query.

And also by using the WhereCondition if you open the report by using the DoCmd statement:
DoCmd.OpenReport "ReportName", acViewPreview, , "WhereCondition"