Altering Form for Partial Search Capabilities

[marksparro]

I was referred to this Form from a member from this form. I am currently using it but I need to alter it a little bit and need some help. When i search using this form, I have to type in the criteria exactly as it appears on my table. I was wondering how i could change it so that it would turn up results even if i typed in only part of the data in the field. here is the link to the page i downloaded the form from :

http://www.mvps.org/access/forms/frm0045.htm

If someone is using this form, or is willing to download it and let me know what i need to do to change it, i would appreciate it.

 

[DougP]

Well in Accesss you can use Wild cards to seach.
"*" astersik

So to make it wild card search add this

Like [Enter value] & "*"
use the word Like to start it off put in your values then end it with & "*"

so it will find everythign that begins with something
Like S* will find Smith, Small, Sams

or things finds everything that has those values in it.

Like "*" & [Enter value] & "*"

*S*
WinSton
Small
Smith
yamS
WilSon
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive