Open form with filter will not open to filtered recordset

[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

 

[Rick Brandt]

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

Your quoting looks incorrect to me. Try...

DoCmd.OpenForm "frmEmpl", WhereCondition:"id_code='" & Me.id_code & "'"