>>>I'm using a command button to add a record to file, being diplayed in a grid. On completing the entry, a grid.refresh() is issued but the grid is not being refresh properly. I just can't figure out why ?
>>>Thanks
>>>Sonali
>>
>>You probably need to reset focus to grid temporarily:
>>Thisform.grid1.setfocus
>>Thisform.grid1.refresh
>>Thisform.Controlnext.setfocus
>
>I would think of this as a rather round about method. Does one have to always set the focus to the grid for it to refresh properly ?
Not necessarily. For example, I used to have all grid resetting code in custom method 'ResetGrid' (it mostly resetting RecordSource/Column.ControlSource) and call it when it's necessary.
Edward Pikman
Independent Consultant