Player Draft-Step 3

  1. Queries button >> Create Query in Design View.
    Add the Players table. Close.

  2. Add all fields. In Criteria row of LastName type
    [Enter Player's Last Name]. Save as Find Player.
    Close.

  3. Forms button >> Players form, press Ctrl+C to
    copy the form, then Ctrl+V to display the Paste
    As dialog box. Enter Find Player, then click OK.

  4. Open the Find Player form in Design View.
    Properties >> All tab.

  5. Record source >> Find Player query. Close the form.

  6. Double click on Find Player form >> Enter the last
    name of some exsiting player >> Click OK
    You should see a form displaying the player's
    record. Close the form.