Remove Warning for Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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


James Stephens said:
I have a combo box on a form and I use it to delete records. It will delete
Click to expand...
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
Click to expand...
error message, but then after it, it also displays the default Access message
leting me know I entered a value not in the list.
 
Back
Top