VB5 Combo Boxes

[CM670]

How can i hide an item from a combo box. For example the combo box contains module1, module2, module3, higher module. I want to hide 'higher module' from certain users?

Thanks.

 

[Mr. B]

The answer depends on how the combo box is being populated. Both solutions would require the use of VBA.

If the combo box is being populated with a query then you can update the QueryDef and provide criteria that will prevent that value from being displayed.

If the combo box is a Value List then you can submit a new list of values, excluding that value, as the Row Source of the combo box.