Names list with tabs (2003)

Topic

New Reply

I want to access a list of names from tabs in a form. I want 27 tabs with one letter in each tab.

Reply | Quote

Replies

Can you explain more in detail what’s your question ?
If you want to do a selection on the first letter first letter of the name, in attachment a filter solution with command buttons.

Reply | Quote

What I am trying to do is figure out how to put tabs with the letters of the alphabet of some sort on a form so I can pick a tab and it will go to the names in the list that start with that letter.

Reply | Quote

Why would you use tabs for that ?
Did you want 27 tabs with 27 subforms with each the same recordset with 27 different where conditions ?
Why don’t you like the command buttons in my demo ? Have you look at it ?

Reply | Quote

I don’t recommend trying to use a tab control. See if this is more like what you want. This is implemented as a single form view, but I’ve used the same technique with continuous forms.

Reply | Quote

I would probably just use a combo box w/ the alphabet in it to limit the amount of buttons on the form. you can just type the letter you want and then have a query filter on that, all you need to do is have a table with the alphabet, your regular table, and a simple query to filter based on the combobox.

Reply | Quote

But that is when you want to *filter* the recordset. The poster indicated that he wanted to go to the names in the list starting with a particular letter, which doesn’t necessarily entail filtering. Clicking on a button to move to a point in a recordset requires a single click, which is less complicated than selecting from a combobox or typing a letter in and then hitting enter or clicking somewhere, and you don’t need a method for showing all records as you do when you filter.

Reply | Quote

Francois,

I have done this type of thing with a listbox and the letters down the left side and a lot more code than you have used in your attachment. I really like how simple this is and will use this as an alternative in future.

Thank you!!!!!

Carla

Reply | Quote

I have used Francois solution which he helped me with some time ago & have been very happy & impressed with it!

Reply | Quote