Select Found Subform Record

C

croy

I have this code (from Dirk Goldgar):

Dim frm As Form

DoCmd.OpenForm "frmDE2"

Set frm = Forms!frmDE2!frmDE2DetObj.Form

With frm.RecordsetClone
.FindFirst "DE2DetId=" & Me.txtDE2DetId
If Not .NoMatch Then
frm.Bookmark = .Bookmark
End If
End With

.... and it works very nicely.

But I'd like for the selected subform record to stand out a
little more, and I'm thinking that it would if it were
*selected* after it is found. So far my attempts have
failed. What do I need to add?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting focus on subform row 3
subform used for changing mainform record 0
Assistance with Subform Synching 9
Return to viewed record after requery 10
Delete Record Button with Confirmation Message 6
Add record, return user to that record. 9
finding a record in another form 3
intermittent problem bookmarking record to subform of itself 0

Top