Forms with multiple tabs from multiple tables

[Guest]

I am creating a form for viewing and entering information. A form with
multiple tabs is needed. I would like a tab for each table. How do I do
this if possible?

Thank you

 

[Guest]

Create forms based on each of the tables and embed them as subforms on
separate pages of the tab control.

Ken Sheridan
Stafford, England

 

[Guest]

Ken,

Thank you for your reply.

Now how do you embed them?

 

[Guest]

Once you’ve created the individual forms and added a tab control with the
required number of pages to the parent form you can do it in two ways with
the parent form open in design view:

1. Select the relevant page of the tab control and from the toolbox drag a
subform control onto the page. In the subform control’s properties sheet
select the form you want on that page as its SourceObject property.

2. Select the relevant page of the tab control and drag the form you want
on that page from the database window and drop it on the page. Access will
automatically add a subform control with the form as its source object.

Ken Sheridan
Stafford, England