I have a city table and form that allows you to add a new city to keep growing the list on the fly. I have a button that is to save and close the form after you add a city name. It does have an error event that tells in you in length a confusing message for the error. I don't want to change this error event because I want it to still pop up if there is a different error. because it seems this is an all purpose error handler.
I am new at macros and I can't seem to figure out the argument that will check my CityName text box and see if its a duplicate and then give me a message box saying this city is already entered. Go back and try again. Is there a quick and easy way to do this. I want to use a macro because I don't know anything about vba code and the macro is already started for the save and close button.
Any help would be greatly appreciated. I have guessed at this for about two hours now and I am about to give up.