Subform Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help with subform...
I have a subform that is in DataSheet view. I am using the below code on
the "On Click" fuction in the [product_id] field of my subform and when the
user clicks on the [product_id] field it populates the main form with the
current [product_id} information. What I would like to do is have the user
click on the line indicator on the left side of the row and have it populate
the form, is this possible or is there a way to have it work with all fields
without coding all the field on click.
thanks
Private Sub product_id_Click()

If Me.NewRecord Then
Me.Parent!product_id.SetFocus
RunCommand acCmdRecordsGoToNew
Else
Me.Parent.Recordset.FindFirst _
"product_id=" & Me.product_id
End If

End Sub
 
Raj said:
Help with subform...
I have a subform that is in DataSheet view. I am using the below code on
the "On Click" fuction in the [product_id] field of my subform and when the
user clicks on the [product_id] field it populates the main form with the
current [product_id} information. What I would like to do is have the user
click on the line indicator on the left side of the row and have it populate
the form, is this possible or is there a way to have it work with all fields
without coding all the field on click.
thanks
Private Sub product_id_Click()

If Me.NewRecord Then
Me.Parent!product_id.SetFocus
RunCommand acCmdRecordsGoToNew
Else
Me.Parent.Recordset.FindFirst _
"product_id=" & Me.product_id
End If
End Sub
Click to expand...


That looks knind of somehow backwards to me so I can't
unravel whatever you're trying to do here, but I can tell
you that the record selector responds to the Form's Click
events.
 
Back
Top