Search a field in my database using infopath form

[regdent]

I have created a database and an infopath form which links fine but what i am
trying to do is search in one of my boxes but not for the full name just one
of the words inside a field.

The retrive works fine if i fully type the whole of the field but looking to
just type in one word to find the info.

Is that possible?

Any help would be greatly appreciated.

(Using infopath and access 2007)

Roy

 

[Clay Fox]

We do it all the time with code. Text based search. If you have the data in
a database you could search within the field in the form or the table.

You could use a contains rule in InfoPath but I think using code will
perform better and be more reliable.

 

[regdent]

Can you help me with the code i have no idea when it comes to writing code.
The datbase name is IT Issues DB, the table name is issues and the field is
Title. I would really appreciate any help.