Search notes:
Access: DoCmd.FindRecord
DoCmd.FindRecord
searches for records in either the currently selected column or in all columns (if OnlyCurrentField
is explicitly set to acAll
).
FindRecord
searches case insensitively by default.
DoCmd.FindRecord(FindWhat [, Match [, MatchCase [, Search [, SearchAsFormatted [, OnlyCurrentField [, FindFirst ]]]]]])
Find value which starts with solv
in all columns of the table localContract
. Search case insensitevly
doCmd.openTable "localContract"
doCmd.findRecord "solv", match := acStart, onlyCurrentField := acAll