Button to add a new Tab Page?

[JimmyB]

Having a quick look into using a subform with Tab pages to show info & I'd like to be able to create a new sub-record & to show it in seperate Tab page.

This as it seems a good way to display the info I'm wanting but help files suggest can't be done as need to be added in design view. Is there any way around this?

Basically want a button that adds the new Tab Page in the subform & renames it.

Any ideas?

ta,

J

 

[KenHigg]

I think your next best option is to change a tab caption and maybe a subform source with the button.

 

[missinglinq]

The normal strategy when you want to "add" controls to a form is to place them in the normal fashion, in Design View, set their Visible Property to No on opening the form, then setting Visible to Yes when you need to "add" them You can also change the Caption on the Tabbed Page at this time.

 

[JimmyB]

The 'make them visible' when needed was the next thing to look into but it just feels like going against the grain to create unused pages!

Thanks,

J

 

[KenHigg]

It could also be bad juju to have a bunch of extraneous 'bound' forms/data.