Link to home
Start Free TrialLog in
Avatar of James0903
James0903

asked on

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.
Working-Database1.accdb
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of James0903
James0903

ASKER

I will give this a try.  Thank you again capricorn1.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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).
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial