PaidtheUmpire
Programmer
I have a grid which has approx. 150 records, seperated into 10 groups.
The data is in this form...
Record_ID (PK), Name, Address, Group
What I want is for there to be a ComboBox/ListBox which when selected display only those from that group in the LookupGrid.
For Example:
If in the ComboBox I select "AUSTRALIA", then I want to be able see ONLY the Australian Members in the lookupgrid. The if i change it back to "ALL" then all of the members should appear.
Any help?
The data is in this form...
Record_ID (PK), Name, Address, Group
What I want is for there to be a ComboBox/ListBox which when selected display only those from that group in the LookupGrid.
For Example:
If in the ComboBox I select "AUSTRALIA", then I want to be able see ONLY the Australian Members in the lookupgrid. The if i change it back to "ALL" then all of the members should appear.
Any help?