Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Calling a report from ms access

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
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.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

879 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