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?
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.
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?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.