I am using a Datagrid with ADO code bindings.
To go to a single record view I use the following code when I click on a
particular row in the datagrid:
Private Sub adoPrimaryRS_MoveComplete(ByVal adReason As
ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As
ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
recposition = adoPrimaryRS.AbsolutePosition
and then when the Single record FORM is loaded, I sue the following code to
get to that record in the Datagrid:
Private Sub form_activate()
On Error GoTo GoFirstError
adoPrimaryRS.Move recposition - 1
This works well but it looks like a pretty primitive method. Is there
another property that I can use to select a particular record?
Thanks,
John