Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DoCmd.FindRecord default settings

Status
Not open for further replies.

purdyra

Programmer
May 7, 2002
1
US
Hi,
i have a icon the access wizard created that lets a user click on and the Find dialog pops up, with certain options such as search, match, etc...

i want to set the options to Search = all and Match = any part of field.

i have found this code in vba
DoCmd.FindRecord findwhat[, match][, matchcase][, search][, searchasformatted][, onlycurrentfield][, findfirst]

but this does not pop up the Access box for the user to choose, it's hardcoded or can be passed thru from a msgbox but i want the original look & feel.

i also used:
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
but the defaults can't be set that i see.

anyone know of any other ways or ideas? thx.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top