Can you try using this in your code
=TABLEUPDATE(.T.,.T.,<table to update alias>)
Flush
=Requery(<alias>)
You can take a look at VFP Help on different Buffering Types and TABLEUPDATE.
>Dave:
>I am using buffering. On my form I have a listbox which shows the records in the table. The form also has an add/save button. When I do the "save" I issue tableupdate() and also do the "...requery" to the listbox. As a result, the listbox DOES get refreshed with the newly added row... great.
>Then when I click on the newly added row in the listbox, within the click(), I do a LOCATE on the table, and it never finds the newly added row in the table. It finds all the others ok. It's as if the row has not been committed. I thought the tableupdate() function was supposed to commit changes to a table, but it doesn't seem to be happening here.
>Rich
Sanjay Dhiraj Patel
MCSE, MCDBA
Net2Biz (Thailand)