Is this WineCode already in the list? 1

[munger]

I have a form for a winemaker. He enters the name of the wine by choosing with a combo box. The combobox saves the WineCode (three letters) in a field called WineCode. How do I know if he is entering a WineCode that already exists in this database?

Thank you much.

 

[andrewvanbeck]

There is a property for combo and list boxes called 'On not in list', you just specify a macro or some code to run on this property. For example you may wan't to open a form to create a new winecode.

HTH

Andrew.

 

[NoteSmith]

Make sure the field has a unique index.