What i'm trying to do is show a list of names in last name alphabetical order, then i want a text box somewhere on the page, if box is "" then shows all records, if text is typed into box then it refreshes that data to only show matching records!!
I know this can be done using a LIKE on the query with TextBox% kind of thing, thats not the main problem.
I want the list to automatically update every letter pressed, i.e. b - all names last name starting with b, then if i then typed an r, display would be br and list would only show last names starting with br!
Do i use a refresh, but will i then lose what i have typed in the text box? Session variable?
Any help, i know this can be done!! just don't know how!! Cheers and Stuff
DaveSmith
I know this can be done using a LIKE on the query with TextBox% kind of thing, thats not the main problem.
I want the list to automatically update every letter pressed, i.e. b - all names last name starting with b, then if i then typed an r, display would be br and list would only show last names starting with br!
Do i use a refresh, but will i then lose what i have typed in the text box? Session variable?
Any help, i know this can be done!! just don't know how!! Cheers and Stuff
DaveSmith