Welcome to Dream.In.Code
Click Here
Getting Help is Easy!

Join 117,157 Programmers for FREE! Ask your question and get quick answers from experts. There are 2,319 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now!



Query ListBox function in Access VBA

 
Reply to this topicStart new topic

Query ListBox function in Access VBA, Access, VBA, ListBox, Query

souptoy
post 18 Jun, 2008 - 09:32 AM
Post #1


New D.I.C Head

*
Joined: 17 Jan, 2008
Posts: 23



Thanked 1 times
My Contributions


Hi all,

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.

Chris
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 10/6/08 10:49AM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month