Parametric Report

[university1522]

Hi Everybody,
Hello Everybody,
Here I am trying to open a report, created in microsoft Access database. It is report created from parametric query and I want to set its (report's parameter) by code.Code used in given below. But I think my syntex is wrong and also could not find relevant code in Access help. If any body can guide me, where i am doing mistake? or does any body have code to open a report created from parametric query from AutoCAD VBA environment ?? Plesae help me i will be thankful.

access.DoCmd.OpenReport "CityOfficerQuery1", acViewPreview,, ["Enter ProjectID"].String = UserForm2.CmbBoxReportProjectID.List(UserForm2.CmbBoxReportProjectID.ListIndex)

 

[lupins46]

Go here:

http://ourworld.compuserve.com/homepages/attac-cg/

Choose Code & Design Tips from the left panel; then choose Reports.

You will see the example on the right hand side.