Requerying a list box based on a query problem

[JamesWB]

Afternoon all.

I have a list box (List25) that is generated from a query (qryThisBox). One of the fields in that query uses the criteria [Forms]![MyForm]![SelectedField] to filter.

I also have combo boxes in the form that List25 displays in. Unfortunately, I want to requery the list box in the form, using a combo box that calls the same underlying table field, SelectedField.

How can I do this? Can I somehow dynamically change the criteria in qryThisBox to change when it gets requeried?

How do I stack combo box requeries, eg:

Combo Box 1 gets selected - does a requery

and/or

Combo Box 2 gets selected - and filters the results of the requery for Combo Box 1.

Many thanks for any pointers!

James

 

[JHB]

I think you are asking for Cascading Combo Boxes and List Boxes, below is a link how to do it.
http://www.fmsinc.com/microsoftaccess/forms/combo-boxes/cascading.html