Tab controls (1 Viewer)

[Charlie]

Dear Access-ers,

I am trying to update the names and number of pages in a tab control so that only current departments (things are likely to change quickly) are shown to the user.

I would like to have it so that when the form is started the tab control looks to see which departments exist today and then changes the tabs to fit.

I've tried to add a new page but it tells me I can't do this outside of design view (ver. Ms Access '97 SR1).

Is it possible to use a tab control in this way or do I have to do it with a boring subform??

Thanks for your time,

Charlie

 

[Pat Hartman]

I've always wanted to use the tab control that way too but, had the same trouble you're having.

How about creating a form with a list box (or treeview) control that lists departments and when you click on a department the data fields on the right part of the form are populated.