Find record in another form 1

[JesOakley]

Using data in one form, I wish to find a record in another. It looks like FindRecord is the answer, but I'm not sure of the syntax for the 'front end' of it to make it do the action in the remote form. Can anyone help? I thought something like

forms!frmRemote.FindRecord(varWhat,,true,,true)

?

 

[Remou]

You can use the recordsetclone of the second form:

Set rs=forms!frmRemote.RecordsetClone
rs.FindFirst "ThisTextField='" & ThatString & "'"
If Not rs.NoMatch
'Found
forms!frmRemote.Bookmark=rs.Bookmark
EndIf