Recent content by slj

It works perfectly. THANK YOU, THANK YOU, THANK YOU :D :D :D

Where it is set to 4?

Ok, I have tried both suggestions. The suggestion from June7 gets me every group the company/contacts are a member of, instead of just selected group from lstGroup in the report ex: AHS Lighting (group selected), Koch Furniture,(Company) Diane (Contact) Managhan's Furniture...

yes, they should be the only ones on the report (from the Pictures)

lstGroup shows all of the groups that can be selected lstLeft filters the companies/contacts within that group that the boss wants to contact lstRight is just a display of which companies the boss selected.

Had to zip it. :rolleyes:

I have attached a copy of the db

Good question. I have the report based off of a query lstGroup RowSource: SELECT DISTINCT [qryGroupCoContacts].[GroupCode], [qryGroupCoContacts].[GroupDesc] FROM qryGroupCoContacts ORDER BY [GroupDesc]; lstLeft: RowSource: SELECT DISTINCT qryGroupCoContacts.GroupCode...

GroupCode is a Number

I got 2,2 in the Msgbox

I'm using pbauldy's code to filter a report by a multi-select listbox. I am so close that I can almost taste victory, but I am stuck. All my list boxes behave as expected (see Pic). But when I run the report, it displays all the members of the group, not just the members selected. List...

I am so close that I can taste victory over this monster. :banghead: All my list boxes behave as expected, but when I run the report it is displaying the entire group not just the companies that were selected. ListBoxes: lstGroup lstLeft lstRight - is really just a security blanket for the...

Thanks June7, That is exactly what I needed to do. ;)

The boss has asked me to create a form based on a query that lets him 1. Select from a list of Groups in a listbox , 2. in listbox 2 (multi-select) shows all the Companies & Contacts in that Group, 3. in listbox 3 show which contacts he has selected. He then wants to print a report of only...

Thank you for the welcome. I will be looking for all the help I can get.