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.
'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