Hello all,

Iam a complete beginner, so please be gentle. Im trying to (if possible) create a form to be used as a "search" facility of another form.

All users list their favourite foods:
dave eggs chocolate
steve cheese chocolate
tony beef chocolate

And so in my search I have a combobox of eggs, chocolate, cheese, and beef.
Should eggs be selected I would like only dave to be shown on the next form. Though if chocolate is selected, then all three need o be shown.

So far I've got:
stLinkCriteria = "[food1]=" & "'" & Me![chooser] & "'" And "[food2]=" & "'" & Me![chooser] & "'"
but this doesnt work, and is probably not the most elegant way of doing this.

Any ideas?

Many thanks
Ed

use an IN() operator in your sql statement whenever you have a list of possible values to use:

IN('eggs','cheese','beef')

IN('eggs')

or for numeric values

In(1,2,3,4,5,6)

The sintax may differ as far as whether to use single quotes or double quotes depending on your back end: Access, Sql server, Oracle, DB2, Etc. I get confused...

Are you familiar with VBA or ADO?



Sal