>>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
>
>Edward Pikman always says that INSERT INTO is better... :)
It's in my 'Automatic Reply Manager', else how I could set a record.. :)
Edward Pikman
Independent Consultant