VBA query into a report

[deno]

i have created this form with has a bunch of check and text boxes that the user uses to select what they are looking for. these are used to build a query complete in VBA (it doesn't exist as an actual query). what i'm need to figure out is how to get the record set into a report.

help!
deno

 

[jwindon]

Could you maybe append the resulting recordset to a table and then base your report on that table?

 

[deno]

(sorry i'm a bit new with access)

how would i do this?

thanks

 

[jwindon]

Did you create the records set in design view of the query? Where [Control] = Forms![CheckBoxForm]

You make an append query the same way. In this case the same fields.

On the menu under Queries, Select Append Query and follow the prompts.

If that doesn't help, post again. I'm watching