troubleshooting Question

How to set a combo box in access

Avatar of cheryl9063
cheryl9063Flag for United States of America asked on
Microsoft Access
12 Comments1 Solution285 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros