>I have a simple form. It contains a Grid with some columns from one table and one column from another table related with the fist one.
>When I run that form, Grid shows incorrect value for the related table's column in the first row. All other rows are shown correctly. As soon as I open the edit form on the incorrect row and close it, Fox refreshes the grid and since then it works right. I've tried to use Refresh method for the Grid but It has no result.
>
>Is it a bug or I just miss anything ?
Hi Eugene,
Does this column need to be updatable? I saw messages like yours in the past and had similar problem with one of my application. Since in my case this column was for info only (read-only) I set ControlSource to be
iif(seek(MyKeyFld,'MyOtherTable','SomeOrder'),MyOtherTable.MyDescript,'') and this solved this weird problem. However, I think, you should report it as a bug, especially if you have easy to reproduce test form.
If it's not broken, fix it until it is.
My Blog