Greetings,
In MS Access 2003, I'm using a command button to raise a Find and
Replace dialog so the user can look up records by last name:
txtLastName.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
The option "Match:" currently defaults to "Whole Field". Is there a way
to handle this in code so that this option will default to "Any Part of
Field?"