ACCESS 2007 passing parameters to report not working

[syversda]

I have a report that runs a bunch of code to populate variables and then those variables are used as the control source in my report fields.

for example
var1 gets # of records in a table

I have a field on my report called myfield1 and the control soure is =[var1]

This has always worked in other versions of MS Access but now it throws #Name or #Error in some cases on the report.

I've stepped through the code and the variables are getting the right data on the code side but are not populating on the report side.

I check the references and they are the same on the Access 2002 (Sp2) db as they are on the new Access 2007 db I'm trying to work with but it runs fine on the 2002 one and not on 2007. The references I have checked are:
Visual Basic for Applications
Microsoft Access 12.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
Microsoft Visual Basic for Applictions Extensibility 5.3

Anyone have any ideas why this suddenly won't work?

[ADezii]

I have a report that runs a bunch of code to populate variables and then those variables are used as the control source in my report fields.

for example
var1 gets # of records in a table

I have a field on my report called myfield1 and the control soure is =[var1]

This has always worked in other versions of MS Access but now it throws #Name or #Error in some cases on the report.

I've stepped through the code and the variables are getting the right data on the code side but are not populating on the report side.

I check the references and they are the same on the Access 2002 (Sp2) db as they are on the new Access 2007 db I'm trying to work with but it runs fine on the 2002 one and not on 2007. The references I have checked are:
Visual Basic for Applications
Microsoft Access 12.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
Microsoft Visual Basic for Applictions Extensibility 5.3

Anyone have any ideas why this suddenly won't work?

The Control Source can be a Field Name bound to a Field in a Table, Query, SQL Statement or data generated by an Expression. I was unaware that the Control Source of a Field can be set to a Variable, even if it is part of an Expression. Access will automatically surround any Variable which is part of a Control Source with brackets ([ ]) which normally indicate that the value within the brackets is either a Text Prompt or a Field Name. Please elaborate more on the details.

[syversda]

this is a technique I have used for years - it has always worked for me so it is not something that is new. You just use a variable and pass that variable the same way you would a control source or field.

[ADezii]

this is a technique I have used for years - it has always worked for me so it is not something that is new. You just use a variable and pass that variable the same way you would a control source or field.

syversda, are you 'Passing' the Variable or explicitly assigning the Variable to the Control Source of a Field? I must admit that I'm a little confused.

[syversda]

setting the control source = [variablename]