querying parameters for list box

PaulA

Registered User.
Local time
Today, 04:52
Joined
Jul 17, 2001
Messages
416
I have a listbox that I am using as a lookup tool on a form header. There are also parameter fields there whose sole purpose is so that any combination of paramaters entered will effect what records show in the list box. Clicking a record in the lisbox will then produce the appropriate record in the form.

I have not been successful in creating a query that will be appropriately effected by an combination of parameters (some with a value, some blank).

What is the best way to set up a query so this will work?

Thanks!
 

Users who are viewing this thread

Back
Top Bottom