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 derfloh 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
Joined
May 7, 2002
Messages
1
Location
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