>>>>>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.
Edward Pikman
Independent Consultant