>>>>>>I have a form with a grid based on a view.
>>>>>>
>>>>>>After the TableUdate() in my save method, I issue a Requery() on the view and a Refresh() of the form.
>>>>>>
>>>>>>For a reason I don't know, the Requery() doesn't seem to work, because the grid appear empty. I tried the Next and Previous button, but the grid still appear empty. If I quit the application and go back in, I will see my new record.
>>>>>>
>>>>>There is a good habit: any time you see problems with grid issue something like:
>>>>>Thisform.Grid1.Recordsource=Thisform.Grid1.Recordsource
>>>>
>>>>I tried, without success.
>>>>
>>>This must work, or ...
>>>Select view1
>>>=requery()
>>>Thisform.Grid1.recordsource="view1"
>>>Thisform1.Grid1.refresh
>>
>>I found that it's not the grid who have a wrong behaviour. The Requery() doesn't return any record. If I browse the "Products" table and redo the Requery() now it show the new record. Why?
>
>Do you have buffering on table? If yes, you should first tableupdate() on table itself (browsing there you fire it implicitly) and then requery() data into view. Actually, it will allow you to show records in grid, however IMHO you better use buffering on view and no buffering on table.

Yes, I do have buffering on the tables.

I added a TableUpdate() for each of the 2 tables "Products" and "ProductList" and it work now.

I thought that the TableUpdate() for the view would be enough, but it doesn't seem so.

Thank you very much for your precious help.