Administrator: Receipts (Start) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

Edit the Form

2. Add the New DateRetuned Control

Close any tables you might have open.

Open ReceiptSubform in Design View.

 

Add the Control: DateReturned

Go to the Design Tools.

Select Add Existing Fields.

 

 

You should see the Field List: this is the list of the fields in tblMovieRented, the Record Source for this form.

 

Double click DateReturned to add it to the ReceiptSubform

 

Adjust the layout if you need to so that the Controls are not overlapping. Save your changes and close the subform.

Form Design Tools ->Design -> Add Existing Fields
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements 

  2.7. Modify the design of reports and forms       

  2.7.1.   Add controls: Add fields from tables as controls