List Boxes for Criteria

  • Thread starter Thread starter Matthew Ellis
  • Start date Start date
M

Matthew Ellis

I wasn't sure which group to post this to, but I would like to use a List Box to pass criteria to a query. I have done this many times with a combo box with great results, but this time I need the user to be able to select multiple items in the list box and the query displays only the items selected. I know the query works to show everything without the criteria, but when I put in the criteria I get no records. In the Criteria for the field on the query I am using [Forms]![Test]![List2] . This is how I would do it if it was a combo box. It doesn't seem to work for the list box.
Thanks for the help.
 
See The Access Web article:

http://www.mvps.org/access/forms/frm0007.htm

--
HTH
Van T. Dinh
MVP (Access)


I wasn't sure which group to post this to, but I would like to use a List Box to pass criteria to a query. I have done this many times with a combo box with great results, but this time I need the user to be able to select multiple items in the list box and the query displays only the items selected. I know the query works to show everything without the criteria, but when I put in the criteria I get no records. In the Criteria for the field on the query I am using [Forms]![Test]![List2] . This is how I would do it if it was a combo box. It doesn't seem to work for the list box.
Thanks for the help.
 
Back
Top