Searching recordsets of inactive forms

[eussias]

I currently have a text box and command button on each form for a project I'm working on. The user enters a number into the text box, presses the command button, and the relevant record is displayed. If there is no record, the user is informed. My question is, am I able to also scroll through the recordsets on the other inactive forms at the same time looking for the number, or do I just have to open each form at that specific record?

 

[ide]

i think so: yes.
if the "Form1" object variable a pointer to your inactive form

myRecSet = Form1.recordsetclone

after the myRecSet searchable step by step the records or with the FindFirst, Findlast, FindNext methods

Syntax:
recordset.{FindFirst | FindLast | FindNext | FindPrevious} criteria

 

[eussias]

Not fully following what you're saying. I've set a pointer to the inactive form, but am now stumped

 

[ide]

(DAO example)
...
dim MyForm, MyRecSet as object
Dim strCriter As String
set MyForm = Forms("...&quot
set MyRecSet = MyForm.RecordsetClone
MyRecSet.FindFirst
strCriter = "[ID] = " & myIDVariable & ""

With MyRecSet
' Populate recordset.
.MoveLast
' Find first record satisfying search string. Exit
' loop if no such record exists.
.FindFirst strCriter

If .NoMatch Then
MsgBox "No records found with " & _
End If
'.......
end with