Limit to list property on a combo box

  • Thread starter Thread starter hesperian
  • Start date Start date
H

hesperian

I have a combo box that is looking up values in an inventory table. I want
to set up the limit to list property and the on not il list event to display
a custom dialog box, whick happens however the stock limit to list message
also appears. I need to disable the standard error message when a user
enters a value that is not on the list. I will not be having the use enter
a new value into the table at the time of this event. I just want the user
to be alerted to the fact that he input a value that is not listed.

Thanks in advance
 
you have to set the Response argument in the NotInList event, as

Response = acDataErrContinue

suggest you read up on the NotInList Event topic in Access Help to better
understand how it works.

hth
 
btw, i just noticed that this is the .macros NG. to handle the NotInList
event properly, you need to use VBA code, not a macro.

hth
 
Back
Top