>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?