hi all,
i need to do a record search in a form where its Record Source is Operation,
but instead of searching the Operation, i need to search different table, say Remark..
i supposed the red highlighted code should be the place to set the Remark table, but
how to do this? if there's other way to do this i would like to try too.
Thanks
'SEARCH FOR THE RECORD IN Operation TABLE
Dim rs As DAO.Recordset
Set rs = Me.Recordset.Clone
rs.FindFirst BuildCriteria("[IDOp]", dbInteger, OpNameClick)
If Not rs.NoMatch Then 'MATCH FOUND SET BOOKMARK
Me.Bookmark = rs.Bookmark
Else 'CLOSE FORM
DoCmd.Close acForm, stDocName
End If
rs.Close
Set rs = Nothing