Fields and Tabbed Forms- Help 1

[Uriel365]

I have inherited an Access 97 database that incorporates the use of tabbed forms. However some of the fields appear to be bound to individual tabs while others appear on all of the tabs. I encounterd this when inserting a new tab as three fields will automatically show on any newly inserted forms !! How do I stop these fields showing on the new tab as deleting them deletes them from all the tabs ????

Any help would be gratefully received.

 

[KenReay]

Hi

If you create a control on the form, then fdrag it onto a tab, it will appear on all tabs,

to make it appear on only one tab, select the tab, then create the control on the tab, and it is created with the tab (or page) as the 'container'

it is a bit like the way in which a label is 'joined' to a control

for your existing controls, cut and paste them onto the desired tab, BEWARE however if there is code behind the controls, you may need to cut and paste that as well into the relevant events of the newly pasted controls Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Uriel365]

So essentially if I wish to stop these fields showing on every new inserted sheet I would need to recreate each field but bind it to the tab (and not the form) before deleting the originals ?? Or is there a way of unbinding the fields from the form ??

Your help is greatly appreciated.

Paul

 

[KenReay]

Hi

yes as I said you could cut and paste them, it may also be possible to set (.parent? or .container?) prporties in code to achgieve similar result, but I have never done that, so I am not sure of the appropriate property names or if they are updatable in code Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Uriel365]

It worked.

Thanks for your help.

Paul