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

See also

The DoCmd object and its methods .ApplyFilter, SetFilter etc.

Index