Mstef, while that does suit the need, I'm looking for something a little more user friendly, in that our end users are not at all tech saavy. With the help of others, I've come up with an onclick event for a command button. I've also kept a DLOOKUP. Here's the code for IF EXISTS UPDATE ELSE...