Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help. Changing Query for Combo Box to List Box

Status
Not open for further replies.

RDM23

Technical User
May 16, 2007
39
US
I have a query that pulls data based on a form that uses a "Combo Box". Based on what I select in the combo box, it returns that information. I would like to change the combo to a "List Box" so I can select multiple fields. I know how to change it on the form and to select multi select option. My question is, what would I have to change the field in my query to read multiple field choices. Here is my current query that I am currently using for the combo. Please let me know what I would need to change for it to read the list box. Here is the current query.
Like [Forms]![Form_Distribution_Selection_Criteria]![Emp_Group]
 
Only VBA is able to walk thru the ItemsSelected collection.
So, you have to build the SQL WHERE clause in code.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top