Creating a search field similar to the built in Access 2007 function

[DeZZar]

For anyone that has the 'pleasure' of using Office 2007 you will know
of one handy feature built in - its the search function housed in the
record selector bar at the bottom of a form that allows to basically
start typing and it will automatically search any of the fields within
the form for matches and navigating to the first matching record as
you type....

I would really like to be able to build this function into an Access
2003 Database. Basically hoping that I can code an unbound field to
do the same thing!!

Does anyone know if this is possible or have any suggestions.

I am code novice so I will have trouble understanding wholeistic
instructions - just hoping someone has done something similar already
and might be able to share code or instructions.

Cheers
DeZZar

[Allen Browne]

Slightly different, but try this one:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html

It consists of a combo (to select which field to search), and a text box (to
enter the value to find.) You copy the code into your database, copy the
combo and the text box onto your form, and set one property. It figures it
out from there.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"DeZZar" <de**************@gmail.comwrote in message
news:4f**********************************@b38g2000 prf.googlegroups.com...

For anyone that has the 'pleasure' of using Office 2007 you will know
of one handy feature built in - its the search function housed in the
record selector bar at the bottom of a form that allows to basically
start typing and it will automatically search any of the fields within
the form for matches and navigating to the first matching record as
you type....

I would really like to be able to build this function into an Access
2003 Database. Basically hoping that I can code an unbound field to
do the same thing!!

Does anyone know if this is possible or have any suggestions.

I am code novice so I will have trouble understanding wholeistic
instructions - just hoping someone has done something similar already
and might be able to share code or instructions.

Cheers
DeZZar