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??
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??
