Solved

Calling a report from ms access

Posted on 2001-06-10
2
941 Views
Last Modified: 2010-05-18
Hi,
i am trying to call a report with a where clause,
the reports underlying table shld show only
those records with a particular id.

i tried doing this
DoCmd.OpenReport "SizingResultsReport", acViewPreview, , Customer_id = Forms![cust_profile]![Customer_id]

customer_id  - the reports table id
& Forms![cust_profile]![Customer_id] - is the where clause id.

but after doing this also, it show all records from the reports underlying table,


pls help

0
Comment
Question by:chandua
[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 Comments
 
LVL 1

Accepted Solution

by:
guyss earned 20 total points
ID: 6175874
try "Customer_id = Forms![cust_profile]![Customer_id]"
(this should bind the report to the form)

if it does not work
try entering the value in the string:
"Customer_id = " & Forms![cust_profile]![Customer_id]
(this will oen the report with the correct data and not update it -- should be ok for a report).

hope this helped.


0
 

Author Comment

by:chandua
ID: 6175965
thanks guyss. yep its working now.

thank u very much.
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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
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.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

617 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