Find Record Code Help

[STEVENCV]

Hi,

I am quite new to access but have been tasked with creating a database. With the massive help of Severin on this forum, I now have a working database with forms, subforms and reports.

What I wanted to do next was create an easy to use record finder.

I found one here: http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp (Scroll down and it's called 'A Better Record Finder'.

I tried copying and pasting elements from that, including the module and code, into my form 'CC Form' on my attached database.

Needless to say, my amateur attempt has not succeeded.

Could somebody please take a look at my attached database and point me in the right direction?

The search box in question is located on the 'CC Form' to the right of the database.

Thank you.

 

[pbaldy]

I can't test as I don't have 2010 on this PC, but the call to the function being in red tells you something is wrong with its syntax. See if this works:

    Call jst_FindRecord(frmCallingForm:=Me, _
            ctlFindFirst:=Me!cmdFirst, _
            ctlFindNext:=Me!cmdNext, _
            ctlSearchText:=Me!txtFind, _
            ctlSearchOption:=Me!optFind, _
            strFindMode:=strFindMode, _
            strField1:="ClientName")

 

[Severin]

Hi Steven got your call for help.. got here a bit late... but can confirm that Paul's solution works!~)

 

[STEVENCV]

Sorry for the delay in replying. I just tested your code and it works perfectly, thank you!

 

[pbaldy]

Happy to help!