The text you entered is not an item in the list access
Do you want to edit the items in the LIST
I got this error. I just want this text to be change
The following Supplier is not in the list
Do you want to add new supplier
The text you entered is not an item in the list access
Do you want to edit the items in the LIST
I got this error. I just want this text to be change
The following Supplier is not in the list
Do you want to add new supplier
Use the Not in List event on the combo box.
You can display whatever you want, a message box, open a form , ignore it etc ,etc.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
I did not answer this, as I have never used the NIL event to change an entry, only to add a new entry, so was not sure it could do so.?
I would just amend the entry in it's relevant form, then enter that form with the combo in question?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba