Access Saved Forms [MS Access 2007]

[capitolc]

I'm trying and I'm not finding anything with my key words ("vba","report","reference","elements","").

I'm attempting to create a form/report that will call another report (and it's form elements) I have saved in the database. I need to call these elements so I can pass data to them, programmatically. After I pass this data, I intend to print the report. Can this be done?

1. How do I create a report/form object from a report already present in the DB?

2. How can I call the form elements within a saved report in the DB?

[capitolc]

Dim oReport As Report_rptName
Set oReport = Report_rptName
.
.
oReport.Text13.Value = "changed text by hand"
.
.
DoCmd.OpenReport "oReport"

this is what I have... I have a report saved in the database, "rptName".
I want to programmatically populate the report's components, then open/print the report with the updated values I programmed.

Looking at the code above, I'm trying to create an object so I can control it's components before printing. Using the editor, I see a list of Access Class Objects and one of them is the report I have created. My creation of a new object works (compiles without error) because, looking at the blue line, I was able to access and change the value of a textbox I have in the report, rptName.

My trouble comes when I try to use said object. I need to print out the report with the changes/additions I made by hand in the code. The red line is the command statement to print out a report. My problem, I now have an object as my report and I need to make this object a report to print.

When I reference the object, I get the following error message:
""An expression you entered is the wrong data type for one of the arguments""
When I reference the object within quotes (as I would passing the name of the report as-is in the db), I get the following error message:
""The report name 'oReport' you entered in either the property sheet or macro is misspelled or refers to a report that doesn't exist""


I can't figure out how to get this done, the way I want it done. With this additional information, can anybody understand and help me with this issue?

[Leon Kennedy]

From what I can see, the problem lies within your DIM statement.

Your DIM statement looks incorrect to me. You should have your DIM statement as

DIM oReport as New Object

Then you can set oReport to whatever report it is that you're trying to use. Like so:

Set oReport = Report_rptName