Smart Searching

[Natura1]

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

 

[fearoffours]

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.

 

[Natura1]

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!

 

[Natura1]

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