>I have a form with the text boxes bound to a table using the ControlSource property. What’s the best technique to allow data entry into the form without creating a new record, until the user clicks on an Update command? Is this even possible? So I'm rookie.

>>Are you asking how to allow the user to cancel updates to existing records?

Yes, existing as well as a new entry.