Hi,
I have a large table & would like to be able to select some of the records in a listbox based on a key (e.g. Name) entered in a textbox.
e.g.
type "A" in the textbox and all the records having names starting with "A" are displayed in the listbox
then type "N" in the textbox and the list is narrowed to those with names starting with "AN"
then type "D" in the textbox and the list is narrowed to those with names starting with "AND"
etc.
I use Access 2000 & I think I've seen some code to do this, but can't remember where.
Any help would be appreciated.
I have a large table & would like to be able to select some of the records in a listbox based on a key (e.g. Name) entered in a textbox.
e.g.
type "A" in the textbox and all the records having names starting with "A" are displayed in the listbox
then type "N" in the textbox and the list is narrowed to those with names starting with "AN"
then type "D" in the textbox and the list is narrowed to those with names starting with "AND"
etc.
I use Access 2000 & I think I've seen some code to do this, but can't remember where.
Any help would be appreciated.