Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

forms

ResolvedVersion 2007

Lauren has attended:
Access Introduction course
Access Intermediate course

Forms

How do I make or change tabs in the form view?

RE: Forms

Hi Lauren

Tab forms are usually used to display data from two or more tables on a form.

If you need to create tabs on an Access form you do the following:

1. In the form design view select Design under Form Design Tools .

2. In the Controls section select the Tab Control

3. With the mouse draw the area to be covered by the Tab. The Tab object appears on the screen with 2 page tabs

4. Use the Property window to rename the Tabs

5. Click the Add Existing Fields button in the Design ribbon.

6. Select the fields from the relervant table and drag them to the relevant tab page

The form will now allow the user to enter/view data in two or more tables.

Hope this helps

Carlos

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.