Calling a report from ms access
Posted on 2001-06-10
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,