I have created a query and would like to use a list box to have the user select data for parameter query. Is this possible? If so, how would you do it?
Juan C Rivera 3 months ago
When you get into the developer classes you get many examples on list boxes Developer 5 but a free tech help List Box Filter may be a quick answer to what you need.
Kevin Yip 3 months ago
Hi Anjanette, you need VBA to pass the list box value to a query's parameter. The picture below shows how to do it, using the "Parameter" property of a query. I don't know if Richard has a course for this or not. The key thing is that a parameter needs square brackets in query design (e.g. [My Parameter]), but it doesn't need square brackets when it is used in VBA, as shown below.