Report based on form w/multiple combo boxes

[kentwood]

I am not an expert by any means and after several hours of fighting with this I could really use some help.
I have a form based on a table that has multiple combo boxes. I did make a query (with filter) from the table linking to the other tables used in the combo boxes so the fields would correctly show on the reports. So far so good.
Have a button on the form that will print a report for the form selected. The form will print nicely on the few test records I have (1 & 2). But if I add new records (7 & 8)I end up with a blank report, even though the data is on the main table. Frustration has overtaken me. I have attached the database with hopes that someone can set me straight. I have a deadline of tomorrow and have spent last night and today trying to get it straight.

 

[Rickster57]

Joins

Your joins in your query qryworkorderreport are incorrect. All your joins are set to "Only include rows where the joined field from both tables are equal".
You need to set some of your joins to "Include all records from "Workordertable" etc......

In other words if you don't have a matching record from one of your other tables to the field in your Workordertable, nothing will show up in your report or query.

 

[ansentry]

Here is your db back its working. The query that is the source for your report is (in my opinion) is wrong, I would not be using lookups in tables. To make it work I changed the relationships in the query.

I also changed the code behind your "Print Button" and took out the criteria from the query that is the source for the report.

Sorry this is a bit rushed,I am in a bit of a hurry.

 

[kentwood]

Thanks for your help, and I apologize for my late response. with your help, have everything working as I would like.