hi,

I am looking to replace the navigation buttons at the bottom of a
subform with tabs.


I want the tab control to automatically create a tab for each year for
which a record exists.

I.e. the main form will be for one customer. If this customer has
placed orders in the last three years, then I want the tab control to
have three pages (one for each year). Each tab page will have the
exact same fields.


thanks!!

I would suggest a table of Years (YearID, Year) and have YearID as a foreign
key in your order table. Then you just have a combo box on your form to
select the year, and the underlying SQL refering to the YearID

Phil

"andrewbda" <andrewbda [at] gmail.com> wrote in message
news:91c348fb-71fc-4745-baad-d5fb7064e45b [at] e25g2000prg.google groups.com...
> hi,
>
> I am looking to replace the navigation buttons at the bottom of a
> subform with tabs.
>
>
> I want the tab control to automatically create a tab for each year for
> which a record exists.
>
> I.e. the main form will be for one customer. If this customer has
> placed orders in the last three years, then I want the tab control to
> have three pages (one for each year). Each tab page will have the
> exact same fields.
>
>
> thanks!!

i once thought as you did...

i would suggest that instead of tabs that you use a list box that
allows a list of years and the records in those years. then when a
user clicks on that list the subform changes to the record on that
line they clicked. this is a much easier thing to program, and makes
for easy navigation.