[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 945
  • Last Modified:

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

0
chandua
Asked:
chandua
1 Solution
 
guyssCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now