Combo box with subform

[TG_W]

Without a bunch of testing, I would say you could create a second set of combo boxes to work in reverse order or create a second form with the boxes working in reverse order.

If you do two sets of boxes on the same form, you could put a box around the combo boxes with directions on how to use them to search or put an arrow leading from one to the other.

The reason for using one of the above options is the query feeding the second combo box is based on the first box having a value (see post #6, second comment 5.)

[Jerseynjphillypa]

Thanks again for your advice.

[Jerseynjphillypa]

How can I list the "items" and "for" in alphabetical/numerical order in the combo box

[TG_W]

In the query builder for the row source, set the field to Ascending. It's the parameter under Group By.

[Jerseynjphillypa]

Thanks again

[TG_W]

You're Welcome. Glad to help.