I have a combo box that has a record source of amounts in it.. I want the users to only use the combo box to select the data..NOT type in amounts..When a user currently tries to type in an amount they get the error message(in code below).. I dont want them to be able to get that far.. Is there a way to stop them on enter or is there a way to change that error type to a custom error type and take away the VB "end" "debug" buttons they get when they get the error? I want to force the user to have to select a value from the drop down not click in there and try to enter.
run time error 2237
The text you entered isnt an item in the list