Najemikon,
Hold on to your seatbelt. I am so glad you pointed me to finding this thing in Google. I do not know if this is the best or the cleanest or anything but I told 1 line out of each of every suggestion and it WORKS!!!!!!!!!
I will substitute General names so I do not confuse you with my form names and field names.
--------------------------------------------------
MFname = Mainform name
SFname = Subform name
FieldName = Field name on the subform which I wanted to find.
txtSearchField = unbound field on the Mainform which I was using to match against FieldName
--------------------------------------------------
Private Sub txtSearchItem_AfterUpdate()
Dim rst As ADODB.Recordset
Set rst = Forms!MFName!SFName.Form.RecordsetClone
'May need to wait for the recordset to be populated
Do While (rst.State And adStateConnecting) Or _
(rst.State And adStateFetching)
DoEvents
Loop
rst.Find "FieldName = '" & Me.txtSearchField & "'"
If rst.EOF Then
MsgBox ("Field " & Me.txtSearchField & " is not part of this Subform, try again"

, vbOKOnly
Me.txtSearchField = Null
Me.txtSearchField.SetFocus
Else
Forms!MFName!SFName.SetFocus
Me!SFName.Form.Bookmark = rst.Bookmark
End If
Set rst = Nothing
End Sub
I am still pinching myself. YAHOO!!!!!!
Thanks again !!!!!!!!!!!!!!!!!