Find record based on record ID

[GraeagleBill]

In looking among the various forms of DoCmd, I don't find a method like "DoCmd.FindRecord MyRecordID = intNumber". Where such a command would be used in the code sheet of a continuous form. Google spit out some stuff but didn't see anything quite like I'm asking. ("MyRecordID" is the ID field of the current form's RecordSource.)

[Micron]

Are you saying you weren't able to find this
https://msdn.microsoft.com/en-us/vba...or=-2147217396
or that somehow, it's not relevant to your situation?

Your example is a bit more like a DLookup than FindRecord.

[GraeagleBill]

Completely failed to assimilate the meaning of AcFindField as it applied to my situation, problem solved.
Thanks,
Bill

[Missinglinq]

Here's some boilerplate search code, to do this.

If MyRecordID is defined as Text:

Private Sub btnSearch_Click()
 If Not IsNull(Me.SearchField) Then
   Me.Recordset.FindFirst "[MyRecordID]='" & Me.SearchField & "'"
     If Me.Recordset.NoMatch Then
       MsgBox "No record found", vbOKOnly + vbInformation, "Sorry"
     End If
 End If
End Sub

If MyRecordID is defined as a Number:

Private Sub btnSearch_Click()
 If Not IsNull(Me.SearchField) Then
   Me.Recordset.FindFirst "[MyRecordID]=" & Me.SearchField 
     If Me.Recordset.NoMatch Then
       MsgBox "No record found", vbOKOnly + vbInformation, "Sorry"
     End If
 End If
End Sub

Linq ;0)>

[GraeagleBill]

Me.Recordset.FindFirst "[MyRecordID]=" & Me.SearchField

Far more applicable to my situation than "FindRecord". (My mind always seems to think of cloned recordsets when FindFirst.... Next, Last, etc comes into play)
Thanks,
Bill

[Missinglinq]

Glad we could help!

Linq ;0)>