tab control to display alphabatical list

[jirrah]

hi
i have a recipe list , i want to use a tab control on form which can display the recipe list in alphabetical order in individual tabs e.g TAB A showing recipe begining with A, and so on....
thanks for any help

 

[Parker]

hi
i have a recipe list , i want to use a tab control on form which can display the recipe list in alphabetical order in individual tabs e.g TAB A showing recipe begining with A, and so on....
thanks for any help

Err what help would you like?

If I'm guessing right you want to put 26 tabs on a form?

Don't know why you would want to do it but mine is not to wonder why.

Have each tab display the results of a query. That means you will either have to have 26 queries or 26 pieces of code.

A better way would be to code the query and use the label of the tab as the parameter.

Personally I think I would just use a standard query and ask for input of a letter to catch the parameter. That way it will keep it simple and clean--------just a form with a button to run the query. You could even do this from a switchboard.

 

[Rich]

Look at the Customers Phone List in the Nortwind DB. It has a better example

 

[jirrah]

thanks for suggesting northwind.db, i am looking for such thing, but use of macro a bit advanced for me, i am trying to study the code, but if you can give a bit explanation how it works and if there is another more simpler way

 

[Rich]

Just import the form etc. into your own db and change the data source etc to your own table/query