Hi Debra
What I did was create the new record as a memory form. When I have done whatever I can either find the record and change it, or if it doesn't exists add a new record. Has the added advantage of not creating a primed record in MSSQL until I want it to.