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.

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.

I show how to do the first method that Kevin showed in this video: Value From a Form. You can use that value in another form, a report, or a query.