I have a form that has 2 grids.
The top grid has multiple product records and certain columns can be modified.
The bottom grid has the same layout but only contains 1 record that displays the default information for the product selected in the top grid.
Both of the grids have 2 panels displayed.
When the record pointer is moved in the top grid while the focus is in the Right panel, the recordsource for the bottom grid is requeried and the bottom grid is refreshed.
What is happening, is that the Right panel is refreshed but not the Left.
If the record pointer is moved in the top grid again, then the bottom grid is refreshed and the right panel is correct, but the left one now displays the previous information, like 1 record behind.
If I select the Left panel in the top grid, then the Left panel in the bottom grid is correct and the Right panel is 1 record behind.
Any suggestions?
Thanks, David
The top grid has multiple product records and certain columns can be modified.
The bottom grid has the same layout but only contains 1 record that displays the default information for the product selected in the top grid.
Both of the grids have 2 panels displayed.
When the record pointer is moved in the top grid while the focus is in the Right panel, the recordsource for the bottom grid is requeried and the bottom grid is refreshed.
What is happening, is that the Right panel is refreshed but not the Left.
If the record pointer is moved in the top grid again, then the bottom grid is refreshed and the right panel is correct, but the left one now displays the previous information, like 1 record behind.
If I select the Left panel in the top grid, then the Left panel in the bottom grid is correct and the Right panel is 1 record behind.
Any suggestions?
Thanks, David