lookup for value in combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raul Sousa - 11 Aug 2006 10:38 GMT

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?

Reply to this Message

pietlinden@hotmail.com - 11 Aug 2006 11:00 GMT

> 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

Reply to this Message