Microsoft Access

[DSD]

I am creating reports using a query. Within the query I want to build a multi-select parameter. I can't seem to make it work...a single-select parameter works great. The ultimate goal is to have a report with multiple options so users can print it without multiple versions. Any suggestions??...Also will call report using visual basic so I am trying not to use Access Forms.

Thanks

David

 

[Dreamboat]

I don't see how you can have a provision to select multiple values without a user form from which to work. Of course, you could run the form instead of the report from VBA, right? And put a button on the form that'll run the report?

So, if you give in, you can do this:

http://www.mvps.org/access/forms/frm0007.htm

Anne Troy

http://www.TheOfficeExperts.com

 

[DSD]

Ok, I couldn't figure it out so now I know. Thanks for the link, i used it and added my VB level and it all works good....

Thanks for the help.

 

[Dreamboat]

Anne Troy

http://www.TheOfficeExperts.com