Okay heres my question and who ever would be kind enough to answer it I would
like to Thank them In advance.I guess this question is kind of bordering between
a VB general discussion Question and an ADO Database Question. I am working with
ADO, in particular the Addnew method.Let me try to step through my code. Of
course initially I retrieve a set of records using a select statement and then
bind this data to the fields on a form.This Form is used as a utility form to
allow the user to Add Edit and Delete record.When I use the addnew method it
cleared the data from my resultset that I assigned to a Form Level Variant
variable. My problem is I need to use this data to do some validation checks i.e.
if the user fails to enter data for a particular field on the Form I want to be
able to save what was in the Record prior to executing the Addnew method.I hope
someone is understanding ME, anyhow what is the current programming method for
saving the current record's data prior to executing the addnew method?