query criteria from form

[wavequationteledyne]

I have a form with list boxes containing information from a table. I would like write a query which is the record set for one list box that uses the value of another list box for a criteria, but doesn't use anything if the criteria list box has no value selected.

[pbaldy]

Does this help?

http://access.mvps.org/access/queries/qry0001.htm

[wavequationteledyne]

It does, but I can't understand why....

[June7]

Do you want dependent (cascading) listboxes? Example with comboboxes will work with listboxes http://datapigtechnologies.com/flash...combobox2.html

[wavequationteledyne]

now I understand how pBaldy's solution worked, but I have another problem. It worked at first, but then the Access Query design view seems to be corrupting it somehow...

[pbaldy]

The design grid will screw around with it and if memory serves, splits the form reference to a new field. It should still work, but looks goofy.

[wavequationteledyne]

I had to delete the query and rewrite it, but it does work even though the design grid does do what you just said. Now, I'd like to do the same thing with another list box, so that there are two criteria... I'm adding the second field as a criteria, and using the "[control] or [control] is null", but it isn't working as I'd like it to....

[June7]

These are called 'cascading' for a reason. Usually third combobox only needs criteria based on second combobox and second combobox has criteria based on first combobox - like dominos.