Lookup matches while writing in a form

[arne]

Have a form containing one unbound textbox and one listbox. Want to lookup
from tblplace and show the matching field place whie I fill out the
textbox.Writing C will give med Canada, California, China.. Writing Ch will
show me China..

Have used the dlookup code as shown on
http://www.mvps.org/access/forms/frm0009.htm. It works great, but I have to
exit (write everything) before any results are showin..

Any examples or other ways to do this?

arne

 

[Scott McDaniel]

Try putting the code in the control's Change event