Create a "search-by-typing" list

G

GeorgeAtkins

Using Access 2003.

I have a subform consisting of an alphabetized list of names . I would like
to "search-by-typing" in the list. For example, to find "Cebula", I would
start typing "c-e-b-u-l-a" and it would move down the list, to that name. Can
this be done in Access? Thanks.
 
G

GeorgeAtkins

Right. I know about that, Susan. Sorry, guess I was not being very clear. I
was thinking of a way to combine that within the actual subform, itself. That
is, the table would act as its own searching combo-box.
 
S

SusanV

Sorry, but now you've completely lost me - the form should be based on a
table, but the combobox should have the Rowsource set to a (different)
lookup table, or a DISTINCT query of existing names in some table or other.
You can bind the ControlSource to a field in your form is you want to
populate a field with the looked-up value. You can also use the NotInList
event to add to the RowSource if a value you need does not currently exit.

What exactly are you trying to do - what's the purpose of the lookup?
 
S

SusanV

Criminy, beat up by the speel-chucker again. if it does not EXIST, not exit
LOL.

TGIF!!!
 
Top