Select value in drop-down in form, display data in report

I have a MS Access 2007 DB in which the user will select the last name of an agent in the 'Search Form'.  I do not know how to program Access to have the data related to that Agent queried against my main table of "Main" and then displayed in the 'Report' report. Please see attached Database and if you could explain some of the steps taken so I can learn I would really appreciate it.  Thank you.
Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
test this

* set the record source of the report to table "Main"
* set the textbox control source to respective fields from table main

* select an aget from the dropdown before opening the report via  the command button
* apply the "where condition" using the value selected from the combo box when opening the report

James0903Author Commented:
I will give this a try.  Thank you again capricorn1.
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
start with this link

Creating a Report
Helen FeddemaCommented:
Also, it is better to use an EmployeeID (or some such) as a key field.  You may have more than one person with the same last name.  You can set up a combo box to be bound to the key field, while displaying the last name or other meaningful field(s).
Helen FeddemaConnect With a Mentor Commented:
See my Access Archon #42, Selecting a Filter for a Report:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.