This should be simple but for some reason I just can't get it! Here goes... I have an access form with an unbound text box an unbound combobox which filter and retreive information. What I need to do is put an error check in to make sure that if the user enters a number larger than 202 in the text box that they have also made a selection from the combobox which is between rows 9 - 14 in Column(1). For example,
If txtoitemID.value > 202 then
cboLabourType.column(1)= "Assembly" or "Spraying" or "Shipping" or "Packaging" or "Metal" or "Milling"
else Msgbox "Your order item number must be greater than 202"
end if

Assembly is in row 9 and Milling is in row 14 of the column.
I know this code is not right however, I hope it will give you a general idea of what I am trying to do.


Liza