You'll have to copy this sub to the Combo1 exit event to populate the listbox without the Distinct filter for all the data.'your SQL statement stSQL = "SELECT DISTINCT Region FROM Region_Mapping"
Hope this helps!
You'll have to copy this sub to the Combo1 exit event to populate the listbox without the Distinct filter for all the data.'your SQL statement stSQL = "SELECT DISTINCT Region FROM Region_Mapping"
Hope this helps!
Last edited by Aussiebear; 04-19-2023 at 02:05 PM. Reason: Adjusted the code tags
David
Posting Permissions
Reply With Quote