View Full Version : Filtering with a Combo Box


jevans
01-25-2001, 03:54 PM
Here's my problem!

I have three forms setup lets call them Main, Sub1, and Sub2. The Main form has a textbox used as a search field( using the Like command as an After Update event). Double Clicking in one of the fields will open Sub1 linking the information by the field. Double clicking a field in Sub1 will open Sub2 linking the information by the field.

In Sub2 I would like to filter this data further with a combo box. I would like the combo box to generate its data from Sub2.
My field has dupilcate information so I would like to group similar data and present it as one entry in the combo box.

Is this possible??

TGHockett
01-25-2001, 07:10 PM
jevans ... I have accomplished something similar to what you are trying to do (I think), by having a combo box in a popup form give the user the selection of the filtered data they are interested in.

Might this be an alternative for you to consider?

TGH