Solved

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

Posted on 2011-02-16
5
984 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
  • 2
  • 2
5 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 333 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 119

Assisted Solution

by:Rey Obrero
Rey Obrero earned 333 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 167 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Export  Access Query To Excell 16 43
DSum for Access 6 42
Cross Tab with two column values 7 30
SQL Query Conversion of IIF statement into CASE - Syntax issue 17 28
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

939 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

Need Help in Real-Time?

Connect with top rated Experts

5 Experts available now in Live!

Get 1:1 Help Now