>The way I used to add a new record to a table was the user would fill in the fields, and then press SAVE. The system would then APPEND BLANK and REPLACE.
>
>By using .ControlSource, however, I have to APPEND BLANK first before the user can add anything to the table. If, however, the user changes their minds about adding a new record, a blank record is still in the table. I could check key fields, and if they are blank delete the record, but I was wandering about how everyone else is adding a new record to a table. Any input?
>
>Ed
Ed,
Enable table buffering and then if the suer says save you TableUpdate() and if the suer says throw it away you TableRevert(). You still need to append blank but the blank record is in teh buffer and not the file on disk.