Autofill combo box

J

jped

I have a combo box that gets it's values from a linked table. The linked
table is linked to a text file with a long list of values. Is it possible to
autofill the combo box as the user types? All my other combo boxes work
where as the user types, it fills it in. It would be useful since this list
is so long. Please help!

Thanks!
 
L

Larry Linson

jped said:
I have a combo box that gets it's values
from a linked table. The linked table is
linked to a text file with a long list of values.
Is it possible to autofill the combo box as the
user types? All my other combo boxes work
where as the user types, it fills it in. It would
be useful since this list is so long. Please help!
Click to expand...

To me "linked table" is a TableDef in this database linked to a Table in a
different database. "linked to a text file" would imply a similar link to an
external file with records containing the values. Just to make sure that we
understand your environment, could you clarify / confirm?

What you want to do may be as creating a query with both the key and the
text, using that as the RowSource of your Combo Box, specifying both columns
and hiding the key column, showing only the text. But, depending on your
environment, it may not be that simple.

Larry Linson
Microsoft Access MVP
 
Top