Create a "search-by-typing" list

[Guest]

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.

 

[SusanV]

Sure - use a combobox, that's it's native behavior.

 

[Guest]

don't you hate it when the natives misbehave!

Sure - use a combobox, that's it's native behavior.

 

[Guest]

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.

 

[SusanV]

Well, if you can't be good, be good at it and don't get caught!
;-D

 

[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?

 

[SusanV]

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

TGIF!!!

 

[Duane Hookom]

The Corp Tech Demos has a subform like this at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Letters are combined to
search unless the time between key presses is 3 seconds or a match isn't
found.