Selecting Records to Print

[Papa_Bear_1352]

Hi All

I have an access form with a list box containing a number of customers, column 0 being the customer ID. This list can show different customers depending on criteria that the user inputs and I select the records by building an SQL command. What I want to do is add a button to run a report for all the selected customers. the code at the moment is

stDocName = "RepStdLetter"

stCriteria = "CustomerID = " & Me.CustomerList.Column(0)

DoCmd.OpenReport stDocName, acPreview, , stCriteria

All I get is the customer last clicked in the list box, whether selecting or deselecting.

Thank You

Steve

 

[Fizzio]

You need to loop through the records and build the WHERE clause dynamically. Search here for multi select listbox or modify this code example provided by Mile-O

 

[Hayley Baxter]

Is this sample something like what you're aiming for? It's in access 2000, not sure which version you are using.

 

[Papa_Bear_1352]

Thanks Hayley and fizzio. Took bits from both replys and it works great.

Steve