Player Draft-Step 3
- Queries button >> Create Query in Design View.
Add the Players table. Close.
- Add all fields. In Criteria row of LastName type
[Enter Player's Last Name]. Save as Find Player.
Close.
- 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.
- Open the Find Player form in Design View.
Properties >> All tab.
- Record source >> Find Player query. Close the form.
- 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.