>>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.
Alan,
Read up on data buffering. You turn on buffering for the table and then for a new record you APPEND BLANK into the table and let the user edit, for an existing record you simply move to it and let the user edit. When the user is finished you give them a Save and Cancle buttons, in the Save you do a TableUpdate() and in the cancel you do TableRevert().