>>It looks Ok. If you are absolutely positive that grids are not refreshed properly, but data is really reverted, then there is one good way to force grid to be true:
>>Local cRecordsource
>>With Thisform.Grid1
>> cRecordsource=.Recordsource
>> .Recordsource=cRecordsource
>> .Refresh
>>Endwith
>
>
>I tried to refresh the whole page as Colin suggested but it doesn't work. I tried the above code also but my situation is a little bit complicated. I have combo boxes in my grid. The "recordsource" of the grid is actually a number from a table while the information showing on the grid is the description of the number. In order to do it, I changed the "controlsource" of the column to the description field of a lookup table and change the "bound" property to .F. After running the above code, the grid refresh but the grid is now showing the number instead of the description. Is there any other way to refresh the grid and at the same time have the description shown on the grid instead of the number? Thanks in advance!
>
>
>Chu
You should make above code more sophiticated:
Local cRecordsource
With Thisform.Grid1
cRecordsource=.Recordsource
.Recordsource=cRecordsource
.Column1.ControlSource=....
.ColumnX.ControlSource=....
.Refresh
Endwith
Edward Pikman
Independent Consultant