BESPOKE SEARCH

D

Dave180

What is the VBA Code for the built in Find/Replace box?

If we knew that - we could all then use and tailor it rather than ask silly
questions like "why doesn't acSearchDirection" etc work (like what I do)

cmdSearch...
With "Contacts" etc ...
!FirstName.SetFocus
.Requery
DoCmd.ShowAllRecords
DoCmd.FindRecord SearchStr, acAnywhere, False, acSearchAll, False, acAll,
False
' Works Great
....
cmdNext ...
DoCmd.GoToRecord acDataForm, "Contacts", acNext, 1
!FirstName.SetFocus
DoCmd.FindNext
' appears to work great
....
cmdPrev ...
DoCmd.GoToRecord acDataForm, "Contacts", acPrevious, 1
!FirstName.SetFocus
DoCmd.FindNext
' fails spectacularly!

I've added a Combo box for the initial search direction (all 3 options)
without total success but can't get this feeling that wheels were invented
before my applet!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top