Alphabetical record navigation on mouse up event of label

E

etalent

Guppy
I've got a table with a column of text that is sorted alphabetically. On a form I've got 26 one letter labels of "A" through "Z."

I want to click any of the letters to navigate through the alpabetically sorted records. The "on mouse up" event seems to be the most sensible event to program. How? I have no idea.

Here is an example of what I want to happen:

Table "tblInfinitives" has 35 records that are sorted alphabetically on text field "fldInfEng." Let's say that the first record starting with the letter "e" in field "fldInfEng" is "eat."

Form "frmVerbs" has on it 26 one letter labels of "A" through "Z.." If I click the "E" letter, I should be (record) navigated over to "eat."

My little database is only 219 KB, but that still makes it too big to attach. Please let me send it to you!

Thanks,
- Dave
 
You must log in or register to reply here.
Back
Top