>I have a form consisting of only a grid with three colunms. The source for the form is a view of a single table. I want to be able to refresh the from (actually requery the view) after a row change but not after a column change. Actually I'm looking to refresh the form only after a new record is added or a record is changed. How can I limit the refresh to these events?
>TIA
>--lincoln
If y form contains only a grid, then there is no necessity to refresh at all. However, if you want to refresh recognizing change of row only, then:
1. Create Form property 'gridRecno'
2. Grid.BeforeRowColumnChange event
Thisform.gridRecno=recno("table1") && assuming that 'table1' is grid.recordsource
3. Grid.Afterrowcolchange event
IF Thisform.gridRecno=recno("table1")
RETURN && column changed
ELSE
*** row changed
ENDIF
Edward Pikman
Independent Consultant