>>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.
When stepping through my code, I found a weird behaviour:
- Right after the Requery() I browse the view and it show no record
- I browse the table "Products" (the view is a join between "Products" and "ProductList")
- I browse the table "ProductList"
- I re-issue the Requery() from the command window
- I browse the view and it now show my new record
Any ideas what's going on?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only