Sometimes Access doesn't always give you some things the way one expects.
If you have multiple tables then you would want to create a Form and subForm
using the Form wizard.
If you are working within a single table then what you might want to
consider is first creating a Parameter Query. Make a Query and in design
mode for the name field put this in the Criteria line [Enter Name]
When you press the ! you will then get this prompt i.e. Enter Name....and
it will return all records for that name...
Next just go ahead and create a new Report and in the wizard select that it
be based on this new Parameter Query.....
