We have a datagrid and a hidden textbox on a tab of which the later is populated with the current OpportunityID, and has an OnChange event that triggers the population of the datagrid based on the OpportunityID.  We would like to automatically select the first row of the datagrid after population, but we are unable thus far.  First off, the datagrid's sortable property is currently set to false.  Some of threads here lead me to believe that this property should be set to true to accomplish this.  If that is the case, are there any negative implications to making that change?  Below is our first attempt, but we are not certain if we can reference the ID value of the row, or if a key value from within the row data needs to be referenced.

If grdProducts.Recordset.RecordCount > 0 Then
       grdProducts.Selection.Clear
       grdProducts.Selection.Add(1)
End If 

I cannot locate such a function.  The bulk of the procedures in SLX_Common deal with items that are already selected, none of which seem to alter the selected items except for one function that removes the selected values.

I can see that the OnClick event for the datagrid performs the needed action, but I am not familiar with simulating events.

Create this. You can then pass in your grid and it will select the first row for you. This function comes into a later version - hence you can't find it.

<p>Sub SelectFirstRecordForGrid(aGrid)
 

    Dim blnSortable

 

    If aGrid.Recordset.RecordCount > 0 Then

       blnSortable = aGrid.Sortable

       aGrid.Sortable = False

       aGrid.Recordset.MoveFirst

       aGrid.Selection.Add aGrid.Recordset.Fields(aGrid.KeyField).Value

       aGrid.Sortable = blnSortable

    End If

End Sub

Thanks, that is exactly what I was hoping to find.