VBA and reports

[D.W. Schingenga]

On a report I want to add a value through VBA. However Access does not allow me to add a value to an object. Mine report is based on a table, however I need some information from another table, so I want to use a SELECT statement to get this information and then add the value to a textbox on the report. I get message Error -2147352567 (80020009) during execution. You can not assign a value to this object.

Does somebody know what I am doing wrong?

Thanks,

Dirk

 

[ghudson]

What about using a =Dlookup() [or another D formula] for the text box within your report.

 

[D.W. Schingenga]

I have solved the problem.

Dirk