Hello all,

I have a report that I would like to make that will display records that have been filtered by a user selection. I.E., I have a bunch of records that have associated attributes. I would like the user to open the report, select from a combo box (or some other list) displaying which attribute to use to filter, and have the report display.

I can do this by making a simple query as the recordsource and put in an [Enter an Atttribute] in the criteria area, but that would require the user to know the exact names of the attributes, and there are about 15 of them. I'd much rather use a combo box... how do I do this?

Thanks!

Chris

Put the combos on an unbound form and use a button on the form to run your report. You can build the Where argument of the OpenReport Method using the combos.

Could you elaborate on the OpenReport method?

Thanks,

Chris

The help entry for the OpenReport Method is quite good and should answer your questions.