Hello all
I wrote a code that checks the value typed into a combox is between the limits.
I paste this into the on change event of the combobox:
When for example the limits are 14-20 and you want to type 15 as soon as you type 1 an the error prompts.
the code:
If ComboBox.Value < Me!txtLowerLimit Or ComboBox.Value > Me!txtUperLimit Then
MsgBox ("error")
ComboBox.Value = ""
End If