Using List Box to filter subform

[JokerUSN]

Hi there. I have a form with company information and embedded is a subform displaying a list of transactions based on the company selected. The subform does filter the list off the Company selected in a combo box but shows all transactions the company has ever made. The problem I'm having is that I also want to have the subform also filter off of a list box in the main form of years selected from actual transaction dates in the subform. So, for example, I want to select all transactions for the given company in 2019 and 2018.

1) I assume this is possible but is it possible without using VBA? (not anti-vba, just don't know it well so if something goes wrong, I won't be able to easily troubleshoot)

2) What's the best way to do this?

Thanks!!

 

[theDBguy]

Hi. If the Listbox is multi-select (user selects 2019 and 2018 on separate rows), then it's only possible using VBA. Otherwise, it should be possible without VBA.

 

[June7]

1. No

2. VBA code loops through listbox selection and builds parameter array for us with IN() operator. Review
http://allenbrowne.com/ser-50.html
http://allenbrowne.com/ser-62.html