[b]Main Form & Special SubForm[/b] 1

[trystanhuwwilliams1]

Hi, I hope someone can help me here??

I've got a basic form which holds info on individuals - Name, Job Title. Then I have 3 command buttons and a frame for a subform. I want each command button to open a subform containing different types of information relating to the individual. Each group of data (Address, Qualifications etc ) will be in a separate table.

How can I get the different subforms to open in the main table depending on which command button is clicked?

I only want one subform to be open at a time.

Thanks

T

 

[KenReay]

Hi

Three possible solutions to this:

by using the .sourceobject of the subform control, change the subform in use depending on the button click

by defining three subform controls, each with their own sub form, and fitting exactly on top of each other, set the visible property to true or false depending on the button click

or a different approach, use a tab control with a different subform on each tab

Regards

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

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

UK

 

[trystanhuwwilliams1]

Thank you Ken, I think the first option will suit my needs best.

Thanks for your help