Report out of a listbox

[damdoumaa]

I have a search form that allows the user to search a contact database and obtains contactId, FirstName, LastName and CompanyName the obtained records are placed into a listbox (lstResult)

I want to add a button that would open a report that cotains only the records that are in the listbox (lstResult).
How do I do that?
Please help.

 

[WayneRyan]

d,

Thanks to Pat Hartman ...

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=54924

Wayne

 

[damdoumaa]

This is not the answer I was looking for. I think my question was much more basic.

I have a listbox that contains values based on a search.
I have another button that should open a report that contains only the records inside the listbox.
I created a report that displays all the records in the contacts table "Alphabetical Contact Listing".

On the "Onclick" event of the button i have this code:


stDocName = "Alphabetical Contact Listing"

DoCmd.OpenReport stDocName, acPreview, , [ContactID] = Me.lstContactInfo.ControlSource


I know that the filter or the where condition should be fixed so that I obtain the report that I want. What should I do?

 

[WayneRyan]

d,

If the ID is the first column on your list box:

stDocName = "Alphabetical Contact Listing"
DoCmd.OpenReport stDocName, acPreview, , "[ContactID] = " & Me.lstContactInfo

Otherwise:

stDocName = "Alphabetical Contact Listing"
DoCmd.OpenReport stDocName, acPreview, , "[ContactID] = " & Me.lstContactInfo.Column(0)

The subscript varies from 0 to how many columns in your select.

This is not for a multi-select listbox.

Wayne