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
Solved

Reporting issue

Posted on 2013-11-11
1
198 Views
Last Modified: 2013-11-11
Hello Experts,

I have a contineous form in ms access with a summary of names.

I want to preview the details in a report preview of a particular name if i click the text box

Example:

Names

1. XXX
2. YYY
3. AAA
4. RRR
5. WWW

if i select and click "XXX" from the contineous form

a report preview will open with the corresponding details of information related to XXX

I hope that you will help me

Thanks,

Czher
0
Comment
Question by:Czher
1 Comment
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 39638432
You can do this with VBA in the click event of the Name field:
Private Sub YourNameTextBox_Click()
       Docmd.OpenReport "YourReportName", acViewPreview, WhereCondition := "YourNameField = '" & Me.NameField & "'"
End Sub

Open in new window


You'll have to change that to use your exact names for textbox, fields and report.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
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…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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…

792 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