Search Coding Help

[mitch_johnson]

Hello i currently have the following code for searching for records in my form, can anyone help me adabt it so that i dont need to type the EXACT data as in the record eg if im searching for name i have to put Julliet where i want to be able to search on just julli and it will still find the nearest match. Hope you can help:

Please find code attached in a notepad file

 

[ajetrumpet]

try this one instead mitch.

 

[mitch_johnson]

Hi Adam, That dosent seem to be working do i need to edit it in any way

 

[ajetrumpet]

Hi Adam, That dosent seem to be working do i need to edit it in any way

i personally would have written the code a different way. if you upload your database, i will change it for you if possible.