Smart Searching

Natura1

New member
Local time
Yesterday, 22:41
Joined
May 9, 2008
Messages
3
Hello,

I need some help figuring out how to create a smart search.

Example:

I would like to enter only part of a name in a feild on a form and have all possible matches come back. A good example of what I need is how outlook finds the recipient when you type the first letter of the address. Please email
 
Sorry for not emailing, but it's better for future users if the answer (and any subsequent correspondence that might further identify problems) is written in the thread. Depending on how you've set your prefs you should receive a notification email when others reply to this thread anyway.

I use
Like "*" & "YourSearchTermOrFormFieldContainingSearchTerm" & "*"
As the criteria in a query to do this.
 
That is close to what I need. I am looking for something that will bring a list box to my form and when I select from the list it populates the field.

BTW, Thanks!
 
I have another question. How do I get a field on a form to populate to todays date when I click in it?
 

Users who are viewing this thread

Back
Top Bottom