Creating report from recordset, not table or query

[gellerche]

I want a report based on my tables and a name selected from a combo box. I have two ways of doing this:

1) I have an SQL query in a form that takes the name from the list box and generates a recordset (the recordset is global, so both the form and report can use it). I want the report to use this recordset for its data, but don't know how.

2) I can use a query object to get the name and send the data to the report. The problem is that the only way I can get user input for a query is via a text box, and not the combo box. If there's a way to input data to a query with a combo, then this could work, too.

I would prefer to use option 1, since I don't want to use query objects. If there is anyone who can help, I would appreciate it.

Thank you,

Steve Geller

 

[Chris RR]

OK, wait a minute...why can't you use the combo box in option 2??? This shouldn't be a problem...

Also, why avoid queries in the first place?

 

[gellerche]

Chris:

Thank you for your advice. I thought that I couldn't use a combo and a query at the same time, but talked to someone else who showed me how.

Steve