I have a simple form containing 2 fields from a parent table and 4 grids (child tables). I have the simple data navigation buttons on the form to scroll through the tables. I have modified the _datanav.vcx code to SKIP through the parent table as well as all four child tables. This works fine, my problem comes when I reach the end (EOF()) or beginning (BOF()) of the child tables displayed in the grids. I get error messages saying I have attempted to move the record pointer beyond the beginning or ending records.
I have tried to write IF statements (code below) to reset the record pointer to the top or bottom of the table upon reaching BOF() or EOF(), but I still get the error messages on the child grids.
THIS.Parent.BeforeRecordPointerMoved
SKIP -1
IF BOF()
GO TOP
ENDIF
SKIP -1 IN DEPBL
IF BOF()
GO TOP IN DEPBL
ENDIF
THIS.Parent.RecordPointerMoved
THIS.Parent.EnableDisableButtons
How can I reset the record pointer in these child tables?