Dumferling
Member
- Local time
- Today, 06:46
- Joined
- Apr 28, 2020
- Messages
- 102
I want to understand if I am missing anything. My form is filtered in VBA with setting FilterOn and defining the filter (there are three variables that have to be filtered on - not all of them are present at the time of filtering). I have a list box on the form but to get it to reflect the same filter as the form, I have to set Rowsource which I am doing by using a SQL type statement (I copy the SQL statement from the listbox filter along with the WHERE statement as the criteria). It all works but I am wondering whether I am not missing a trick with the listbox and whether there is not a better way to do the filter than by using SQL statements? Can I,for example, link it somehow to the filter of the form? I am self taught in VBA and not particularly sophisticated so I am wondering if there is something that I am not understanding.