filter combo box

[Guest]

I have a combo box that looks up many product numbers. Therefore information
will be dispalyed on the Form depending on what product number is entered.
Some products have the same product number but different pack sizes. I want
to be able to enter a number and only show those on the combo box. Is this
possible?

 

[Guest]

Hi Kirt

This sound to me to be an ideal time to use a casscading combo set.

The 1st combo will filter the products and the 2nd would filter the pack
sizes.

There are loads of examples of row sources for the 2nd combo in this forum.

Hope this helps