Hi Joe ---
I don't have access to VFP manuals right now so I'm not sure what you mean by table buffering = 2. That being said, by SELECTing the table, doing an APPEND BLANK, and then TABLEUPDATE() you are committing a blank record to the table. You have to get that TABLEUPDATE() out of there and move it to a Save button where the current values in the control are then saved to the new record.
>My form has a data environment with table buffering = 2. The data-entry textboxes in the form have tablename.fieldname as their ControlSource. To add a new record, my add button Click event has the following code: select the table, append blank and execute a tableupdate(.T.).
>
>The append blank works, but no data goes into the table. Can anyone please tell me what I'm missing? Thanks.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05