A-Z On the side of a form?

[Macca]

Hi,

Basically I have quite a big database - I would like a way to get to the beginning of a letter rather than having to click next or search for it.

So if I have A to Z down the side of the form I click on the T, for example, and it takes me to the first record beginning with T.

Is this possible? If so how?

Many thanks,


M.

[NTC]

the embedded capability of the listbox or combobox is that one can begin typing and it jumps to whatever letter(s) are in that list as you go......so most people put one of these in the header of the form.....

the approach you suggest is possible; you would have to set up an underlying query that calls that letter from the form. It is quite a bit more complicated.

[Access_Blaster]

I have seen a sample contacts DB where the person used Tab Controls very tightly compressed A-Z to form a sort of Rolodex. It seemed to be very fast at retrieving the information.

[pkstormy]

Here's an example with A-Z at the top of the form which you can easily re-position to the side or bottom. It uses a simple like statement in the rowsource of the listbox for criteria to query against a text field (that you can add characters to) which is populated when an A-Z button is pushed. I use it in all my apps - works pretty nice and my users like it a lot. The "All" button simply nulls the text field and requeries the listbox. Once the user clicks on the appropriate record, it will open my customer form based on the record selected (ie. docmd.openform "MyCustomers",,,"[IDField] = " & CID & "") where CID is the listbox value.

I also made it so the letter pushed becomes bolded and is in red. There's no complicated logic to the form coding.

[Macca]

Thank you all for your help. I will try the files when I get home tonight and let you know how I get on!

Once again, many thanks.



M.