M
May via AccessMonster.com
I have a datasheet subform that I want to double click on a record in the
datasheet subform and have another form open to that filtered record.
here is my code on the subform..... there is no code on the form that I am
opening.
Private Sub Form_DblClick(CANCEL As Integer)
DoCmd.OpenForm "frmEmpl", WhereCondition:"id_code=""" & Me.id_code & '''"
End Sub
But the form opens to the first record only. How can I modify my code to
open on the record in my subform?
Thanks,
May
datasheet subform and have another form open to that filtered record.
here is my code on the subform..... there is no code on the form that I am
opening.
Private Sub Form_DblClick(CANCEL As Integer)
DoCmd.OpenForm "frmEmpl", WhereCondition:"id_code=""" & Me.id_code & '''"
End Sub
But the form opens to the first record only. How can I modify my code to
open on the record in my subform?
Thanks,
May