You just have to test if the value is a null first. Using a IsDBNull function call. :) http://www.freevbcode.com/ShowCode.asp?ID=5810 or http://msdn.microsoft.com/en-us/library/tckcces5(v=vs.71).aspx

Did you research philo's answer? Did flagging the database not to compile fix the problem? Maybe try that first. If you run the app, stop and then rerun, outside of your IDE and the data is still lost, then you are not saving the data. You need to save the data. "You get that on the big jobs."

Nicely done Why is common sense not common? Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazy Please stand in front of my pistol, smile and wait for the flash - JSOP 2012