Form Validation Rule in Combo Box 2

[rkottke]

Hi,
I have a basic combo box looking up an auto number field. When you type or pick that number the information comes up correctly. However, I would like to set the validation rule up so that if you type in an incorrect auto number (one that's not on the list or if it's a number that's been deleted), I want it to give the data entry person an error message.

Your thoughts are appreciated!

 

[LonnieJohnson]

Set the Limit To List property to Yes for the combo box. ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[Aivars]

Set Limit to List = Yes on combobox Properties window.

Aivars

 

[rkottke]

Thank you!