Open Report without having recod source set

[SnowB1]

I have a form with three combo boxes and am looking to open a report based on the choices they make. After each combo box is selected a query is run that makes a table based on their choice. I want to be able to use the appropriate table, without having to set it each time. The data displayed is going to be the same on the report just different data. Any help would be greatly appreciated.

Thanks

Bobby

 

[WayneRyan]

Bobby,

Instead of making tables, how about making queries. Use the Search
Facility here and look for "QueryDef". There will be many examples of
how your report can use the same query, but have it change each time
it's called.

Wayne

 

[SnowB1]

Thanks for the info guys. I would use the sql statement except I need counts of each of the fields I am displaying on the report. I use a query for each combo box to get the count and create a table to store the values in. I am looking into the querydef now, but I am not sure if it will work the way I have things set up now. Thanks again.

Bobby

 

[SnowB1]

Thanks for the help it works great! Appreciate everything.

Bobby