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

Look in the help for table buffering. You will need to either set the Forms BufferMode or the DataEnvironment tables BufferModeOverride properties. After determining what buffer mode is best suited for your app, set these accordingly. Once that is done, you can use TABLEUPDATE() and TABLEREVERT() functions to either commit or discard any changes the user makes. I know this response is pretty generic, but hopefully this will get you on the right track. Try what I've outlined above and if you need more help, you'll find plenty of folks here willing to help sort out the details.