>I am trying to use two grids on one form.
>A Header File: Parent Table
>A Detail File: This uses a view
>A Sub Detail : File This also uses a view
>
>My detail file always goes to the first record.
>I have tried doing a requery afterrowcol. and it still
>goes back to the first record of the view on the detail
>file. I have also set the a key value and tried doing
>a locate. When I click on the detail grid I put wait
>windows in to see what the value of the records are
>after the afterrowcol fires it goes to the correct
>record and then goes back to the top.
When you do Requery in Afterrowcolchange you actually force new recordset (view) to be created and naturally enough it's created with pointer on the first record. Actually, you don't need to requery the same grid. Grid.Afterrowcolumnchange event should fire (if row changed) requery for the next level grid.
Edward Pikman
Independent Consultant