B
Bill
I am trying to build a pick list of items that have criteria for selection -
but I don't want to hide the items that don't meet the criteria
eg list of:
Apples Fruit
Oranges Fruit
Potatoes Vegetable
Pears Fruit
The rule I want is "allow user to select Fruits but not vegetables"
Selecting a row then executes more code based on the selection.
Listboxes and Combos don't allow me to disable rows so I thought about a
datasheet view subform but I am unsure how to proceed.
Any ideas?
Thanks
Bill
but I don't want to hide the items that don't meet the criteria
eg list of:
Apples Fruit
Oranges Fruit
Potatoes Vegetable
Pears Fruit
The rule I want is "allow user to select Fruits but not vegetables"
Selecting a row then executes more code based on the selection.
Listboxes and Combos don't allow me to disable rows so I thought about a
datasheet view subform but I am unsure how to proceed.
Any ideas?
Thanks
Bill