Search

[Bee]

Hi,

I need to create a form with a search mechanism that brings up a record as soon as you start typing what you are searching for.

For example:

If I want to search for a name called Bee; as soon as I type B the database should return all names that start with B.

Does anybody know about any tutorials/articles on how to implement this please?

Any help will be very much appreciated.
B

 

[The_Doc_Man]

Use the SEARCH function of this forum to look up "Search" topics. (Yeah, search for "search")

Certain options on Combo boxes have the property of "partial search" based on input so far. Read up the Access Help entries on COMBO boxes.

 

[Rylinkus]

I found this to be a wonderful example of a search. Maybe something to this effect could be modified in some way to accomplish what you're trying to do.
http://www.access-programmers.co.uk/forums/showthread.php?t=110203

 

[Bee]

Good example. Thanks.
B