graphic2
graphic1

Exam 77-424: Microsoft Access 2013
4.0 Create Forms
4.2 Set Form Controls: Add Form Controls (Add Existing Fields)

Receipt Form Design:

Add the Customer Data

You can display the customer's name and address in Text Box Controls. The ReceiptSQ Query, the Record Source for the Receipt Form, includes FullName, Address1 and CityStateZip so they can be added as Existing Fields.

 

8. Try it: Add Existing Fields
The Receipt Form is still open in Design View.
Go to Form Design Tools->Design->Tools.
Click on: Add Existing Fields.

 

What Do You See? The Available Fields will be shown in the Field List.

 

Try This, Too: Add Two Fields

Drag three Fields to the Detail Section:

FullName
Address1

CityStateZip

 

In the example on this page, the Control Labels were deleted and the Text Box Controls were resized.

 

Save. Save. Save!

Form Design Tools->Design->Tools->Add Existing Fields