109bow
Registered User.
- Local time
- Today, 07:58
- Joined
- Oct 24, 2007
- Messages
- 141
I have a combo box where users can select from one of a number of even numbers, located in a table. The problem is users can also type a number into the box, they could by mistake enter an odd number, which would return incorrect data.
My question is, is it possible to add a clause somewhere in the combo box properties to restrict typed in numbers to even numbers only.
The row source of the combo box is;
SELECT [even units].[even number] FROM [even units] ORDER BY [even number];
Many thanks
My question is, is it possible to add a clause somewhere in the combo box properties to restrict typed in numbers to even numbers only.
The row source of the combo box is;
SELECT [even units].[even number] FROM [even units] ORDER BY [even number];
Many thanks