Build dynamic WHERE clause in a form

  • Thread starter Thread starter DaveF
  • Start date Start date
D

DaveF

I have a rather complex WHERE clasue to build. For example, I want to
serach the Products table for products of one or more categories.

The WHERE clause could take different several forms:

WHERE category LIKE 'meat' OR category LIKE 'dairy OR category LIKE
'beverage'

or just:

WHERE category LIKE 'meat'

What is the best way to do this on my form?

I can think of two potential possibilities although I am not sure if or how
they could be implemented in Access:

1. I could dynamically build my form with a radio button for each category.
The WHERE cluaes could then be constructed by looping through all the radio
buttons and testing whether they were checked and, if so, use the value to
build the WHERE clause.

2. Use a drop down list with all the categories and build the WHERE clasue
as the user selects items from the list.

Is there a standard paractice for handling this problem?
 
Use a multi=select listbox for the categories and build the WHERE clause from
the categories that were selected.
 
Back
Top