Hello All,
I am having a problem with trying to get around an after update event that runs a clsMod. I believe the Mod is telling it to just put in null values into the fields if no match, but does not run the NotInList.
What I am trying to do is when I enter a ZipCode that is not in the list, I want to be able to open a form per my CboZipCode_NotInList(), so I can put the ZipCode into ZipCodeTable and Put into the CSZTbl also. I of coarse didn't write the mod so I am not real sure how to alter it to let me run the notinlist, or if that is event the problem? I have attached the db which I took out most of the data due to size so I could upload it here.
Form in Question is AddressFrm and the filed is CboZipCode.
Thanks for assistance
Dave
CSZ Data - Copy.zip