I'm trying to run a query that will return records based on multiple values from a multi select list box on a form. I've read other threads and I'm still not able to solve the problem. I have no experience writing queries using SQL, I've only used design view and most of the other threads lead to writing the query in SQL.
I began by trying to take the values from the multi select list box and put them to a text box, then run the query off of that, but the query doesn't recognize it. I tried putting the data in the text box in multiple formats and it still did not work.
If anyone has a solution I would be very greatful. Thank you.
I began by trying to take the values from the multi select list box and put them to a text box, then run the query off of that, but the query doesn't recognize it. I tried putting the data in the text box in multiple formats and it still did not work.
If anyone has a solution I would be very greatful. Thank you.