Q 1. Do i need to create separate recordset for each alphabet (A-Z) ?
Ans: Why don't you create some labels or listbox, so that you can display the alphabets. When user clicks on the alphabet, use the database to fetch the data...
Q 2. How do i get the 1st letter of the name entered into a textbox ? (hav heard that "VB Controls" help...but couldnt find a control to help me..)
Ans: Try this code:
Dim strFirstLetter as string
strFirstLetter=left(trim(Text1.text),1)
)
Q 3. if answer to 1st question is "no" how do i store & Retrieve names of particular alphabet from database when user clicks a label of that alphabet?
Ans:Use a separate data Field in your table to store the Alphabets
Good luck :)
