Using subforms on tab controls

[topgeek]

I am writing an Employee Information database where I need to store, payments, sickness, holidays etc on a per employee basis. Is it posible to have a series of tabs on the main form showing, sickness, holidays etc so that when I move to the next record (next enmployee) on the main form the associated records for that employee change on each tab form?

I have created a seprate sickness table for example and placed that on one of the tabs, but when I change employees the sickness records remain the same.

 

[KenReay]

Hi

Yes, you can do this, have you set the link master/child fileds on the sub form control?

Regards

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

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

UK

 

[ZOR]

Have you setup relationships between the two tables? and did you use the wizard to create your subform? The answer to your question is yes, you can put a subform on a tab. Don't forget to click the tab you want to install the subform on otherwise it will appear on the tab but still be there when you change your tab page.

 

[SammyTBlue]

The simplest thing to do is simply click the desired tab (otherwise, the subform will appear on all tabs-as ZOR pointed out). Then use the "Subform" wizard to add the desired subform to the appropriate tab. Use the wizard to determine the linked fields.

If the subform is already in place, go into form properties (double-click the gray box that intersects both rulers), activate the "Data" tab and set the Master Child links manually.