Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Reporting issue

Posted on 2013-11-11
1
Medium Priority
?
234 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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

569 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