Select Multiple Criteria and generate report

[Invader89]

I'm trying to generate a report based on multiple selections I make from a list box.

 

[pbaldy]

Can't look at the sample right now, but is this appropriate?

http://www.baldyweb.com/multiselect.htm

 

[Invader89]

Can't look at the sample right now, but is this appropriate?

http://www.baldyweb.com/multiselect.htm

Sorry pbaldy I don't know have the VBA background to understand the logic behind the link you provided. Could provide more insight?

 

[Invader89]

Can't look at the sample right now, but is this appropriate?

http://www.baldyweb.com/multiselect.htm

Pbadly I've tried using your code however I'm getting some error. I think your code will work since I already have a report created in the attached db. After the selections are made i would like my report to open based on the selections I made which i think is what your code does. Could please take a look at it? Thank you so much

 

[pbaldy]

There's no db attached (other than the original, which doesn't contain the code), and "some error" doesn't give me anything to go on.

 

[Invader89]

There's no db attached (other than the original, which doesn't contain the code), and "some error" doesn't give me anything to go on.

I think your code also opens a print preview which I would only like to view just the report. Thanks

 

[pbaldy]

Well, you get a parameter prompt for ProgrammeID because it's not in the report's source query.

 

[Invader89]

Well, you get a parameter prompt for ProgrammeID because it's not in the report's source query.

I have added Program. All I'm trying to do is have the button open the Report template I already created and simply refresh itself whenever I choose new selections from the list box.

 

[pbaldy]

It's trying to print, as that's the default. Check the arguments for OpenReport and fill in the one to preview instead of print.

 

[sneuberg]

Try

DoCmd.OpenReport "rptCustomersProgram", acViewReport, , "ProgrammeID IN(" & strWhere & ")"

if you haven't already

 

[pbaldy]

Note that isn't preview mode.