Question regarding Report Parameter

[trimba]

Hi guys,

I have Access Project that links to SQL database, I've created report and bind the record source to SQL stored procedure. When I open the report, It always pop up window for entering all parameters.

Can I programatically populates all report parameters in the code ?

I DO NOT WANT to hard coded the query to filter from form's field value, since I want to open the report from multiple forms. Like :

SELECT *
FROM tblCompany
WHERE companyID = [Forms]![FormCompany]!textID

Thanks

[MMcCarthy]

If for example you had a report based on

SELECT * 
FROM tblCompany

You could then set the filter in the OpenReport statement as follows:

DoCmd.OpenReport "ReportName", , , "[companyID]=" & Me!textID

or if textID is a text field then

DoCmd.OpenReport "ReportName", , , "[companyID]='" & Me!textID & "'"

Mary

[trimba]

Excellent ...

But then If I want to send the report use

DoCmd.SendObject ...

How can you filter the report ?

[MMcCarthy]

Excellent ...

But then If I want to send the report use

DoCmd.SendObject ...

How can you filter the report ?

As long as you don't close the report the filter will not change.