A-Z on a form

[Lucy02]

Hi all

I have a form which lists the name of companies and the contact people within each company. If i want to find the company "Watchdog" for example i have to go through all the records on the form until i find it.

I was wondering if there is a way i can produce tabs on the form letter A-Z so that if I wanted to find "watchdog" i could click on the "W" tab and it would take me straight to the first record beginning with the letter ".

Thanks in advance!

 

[Pat Hartman]

I've actually seen a sample form that does this. I think it might be in the orders or northwind sample database. Or it might be in the forms sample. These are all available on the MS download site.

You could also try adding an unbound combo to the form's header. The wizard will walk you through the process. One of the options will be to find a record on the current form and that's the one to choose. You don't need to scroll the combo. Just start typing and the combo scrolls itself. So if you type "w", it immediately moves to the part of the list that starts with "w". I mention the combo because you can implement it without having to write the code yourself or bother with searching for the sample I mentioned.

 

[ansentry]

Lucy02,

The attached sample db will filter by Alpha, however you say

"take me straight to the first record beginning with the letter"

.

This will only filter the records, if you don't mind me asking why would you only want to go the first record beginning with the letter?