JUlius

JUlius

  • NA
  • 96
  • 0

I need some help on creating a filter from a ComboBox

Jun 10 2008 4:45 PM

This is what I would like do and I need some help.

 

I have a Group form configuration with a datagridview when I can add new groups, and I have two sets of groups  BEST and CECC

 

In the form I have 3 columns ID, CODE, DESCRIPTION. When I add a new group record it can be BEST or CECC, and this is how I plant to separate the two by using the CODE. With in each group I may have the same description example:

 

CODE                  DESCRIPTION

BestTest               Southern California

CeccTest              Northern California           

 

I have an Add New record form, with comboboxes, one of the combo boxes is for the group.

 

I would like to setup two “Option buttons”, one will be for CECC and the other for BEST.

 

I would like to do the following: if I click on the “Option” button for CECC, I would like for only the CECC groups to appear in my dropdown excluding the BEST group, if I click on BEST, I would like to only display BEST group and excluded the CECC.

 

I hope this makes sense.

Thanks,

BK


Answers (3)