?
Solved

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

Posted on 2011-02-16
5
Medium Priority
?
1,017 Views
Last Modified: 2013-11-27
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
0
Comment
Question by:James0903
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1332 total points
ID: 34913053
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



Working-Database1.accdb
0
 

Author Comment

by:James0903
ID: 34913063
I will give this a try.  Thank you again capricorn1.
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 1332 total points
ID: 34913090
start with this link


Creating a Report
http://www.functionx.com/access/Lesson23.htm
0
 
LVL 31

Expert Comment

by:Helen Feddema
ID: 34946480
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).
0
 
LVL 31

Assisted Solution

by:Helen Feddema
Helen Feddema earned 668 total points
ID: 34946497
See my Access Archon #42, Selecting a Filter for a Report:

http://www.helenfeddema.com/Files/accarch42.zip
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question