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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kenjones

    Setting combo box to select all/use all values if none selected

    I have a number of combo boxes set up to allow users to select values with which to query tables. How can I setup these boxes so that if nonvalue is selected, the query is carried out using all values?
  2. kenjones

    using multiple values from a list box in a query

    Further to my previous message, I have set up a list box to allow multiple selections. How can I use these multiple selections in a query to select rows based on each value. the syntax I have (... = [forms]![formname]![listboxname]..)does not seem to work.
  3. kenjones

    Selecting multiple values from Combo Box for query

    I have a combo box set up which is used to query a table by retrieving rows based on a selected value in the combo box. I am trying to add the function to select more than 1 item from the combo box in order to retrieve rows relating to each selection. Is this possible?
  4. kenjones

    Referencing a combo box value in a query

    I am trying to use a combo box on a form to allow a user to select a value with which to query a table. I have created the combo box using a query to retrieve the relevant values from the original table, and have written a separate query which works when I manually enter the value to...

Part and Inventory Search

Back
Top