Currently, I am writing a continuous search form in MS Access that has an unbound Simple MultiSelect ListBox that fills with values from a table. I've got search fields, order by, etc in place and handled by other functions that help create the search results and filter the results. My question is this: I now need to add the selections from the ListBox into the filter string that is created and am having trouble extracting the values selected in that ListBox. What I've thought about doing is writing a loop that gets the current ListBox selection, feeds it to the function I am trying to write, queries the table, concatenates a return string with the results of that single record, and continues to do this through the whole selection. I have some basic code laid out but I'm hitting a roadblock on how to get this done. Any help? I know help isn't really given if code isn't provided but I'm looking for ideas at the moment. Hints on what parameters the function should receive to accomplish this would be great. Thanks in advance.
Query ListBox function in Access VBA
Page 1 of 1
Access, VBA, ListBox, Query
0 Replies - 2528 Views - Last Post: 18 June 2008 - 09:32 AM
Page 1 of 1