Remove Warning for Combo Box

[James Stephens]

I have a combo box on a form and I use it to delete records. It will delete whichever record is selected. I have the property set on the combo box to yes for "Limit to List". Then for my code to delete records, I put in error handling to put up a message if they put a value in that is not in the list. I also put the same error handling message into the combo box property for the "On Not in List" action

It basically works, if they enter something incorrect then it displays my error message, but then after it, it also displays the default Access message leting me know I entered a value not in the list

!!!!! HOW DO I PREVENT THIS MESSAGE FROM SHOWING !!!!!!

Thanks for your help

Jim

 

[PC Datasheet]

Begin your code with:
Response = acdataErrContinue

Notice your sub is looking for a value for "Response"

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

I have a combo box on a form and I use it to delete records. It will delete

whichever record is selected. I have the property set on the combo box to yes
for "Limit to List". Then for my code to delete records, I put in error
handling to put up a message if they put a value in that is not in the list. I
also put the same error handling message into the combo box property for the "On
Not in List" action.

It basically works, if they enter something incorrect then it displays my

error message, but then after it, it also displays the default Access message
leting me know I entered a value not in the list.