Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Calling a report from ms access

Posted on 2001-06-10
2
Medium Priority
?
943 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 60 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

721 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