tab control - different tables

[5166narda]

I would like my main form to have tabs that take me to a different form to update different tables. I have one form to update the customer data and one form to update the exporter data. My main form does not really tie to these separate forms but I would like the tabs on top of the main form to jump to these separate functions???

 

[dcurtis]

Put a form/subform on each tab control. Each will have it's own record source and will update the appropriate table.

 

[5166narda]

I guess I need more instruction. I have a main form and I can create a tab control on it. When I get into the tab control page - how do I put a form/sub-form on it.

 

[dcurtis]

I find it easier to create the form/subform first. Create a form using a wizard or manually. Once those forms are working properly save them. Open your main form, select tab1, add the form to it using the form/subform tool. Do the same for tab2.

Post again if you need more detailed instructions. I would be happy to help.

 

[5166narda]

thanks - that did it.