lookup for value in combo box

[Guest]

I have a combo box on a form.
This combo has a lot of records.
I want to add a botton where the user may lookup for a value and this value
be transfer to this filed.
Any ideas on how to do this?

 

[pietlinden]

I have a combo box on a form.
This combo has a lot of records.
I want to add a botton where the user may lookup for a value and this value
be transfer to this filed.
Any ideas on how to do this?

any reason why you can't set the LimitToList and AutoExpand properties
of the combobox to True?
Then as the user starts typing, the combobox's list shrinks to whatever
matches what he has typed (well, starts with).

What exactly do you mean by looking up a value in a table? If your
combobox's rowsource is a query, then it's _already_ looking up data
from a table