Calling a report from ms access

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

chanduaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
guyssConnect With a Mentor Commented:
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
 
chanduaAuthor Commented:
thanks guyss. yep its working now.

thank u very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.