Combo Box question

[Paul Cooke]

Hi guys

Is it possible to restrict a certain value in a combo box through code?

E.G I have a table called tblNames one of the values in this is table is 'Not known'

This table is referenced on various forms but on some of them I do not want the user to be able to choose 'Not known' from the list

Is this feasible?

Thanks in advance

(for information there is loads of other bits of code behind these combo's events which cannot now be changed as it would have a major effect of the DB structure)

 

[pbaldy]

You should be able to use the before update event of the combo and use

Cancel = True

to cancel the selection.

 

[Paul Cooke]

Thanks Paul