User defined fields using the VB code builder

[l7square01]

I am new to ms access. I am trying to display a calculated value in a text box. The calculated field name is PageSum. In the ControlSource property I set it to: =[PageSum], but it appears that the PageSum variabe is not recognizable to the text box. The PageSum field is not in any database table, it is a field the I defined using the VB code builder.

 

[lupins46]

If you are saying that Pagesum only exists in VBA code then you have to write code to put it into a textbox.

Probably the Print event procedure for the section where it appears.

me.txtPagesum = Pagesum

where txtPagesum is the name of the textbox to hold the total. Giving two things the same name is a route to heartache.

But this depends on how and wher you have defined the Pagesum variable.

 

[capnmark]

You could just use the expression builder to create an expression to find your answer. Expression builder will not
show or recognize vb coded variables but does see the fields included in the recordset for the report and can sum, count, etc. the values. As you said [pagesum] is not a field or the result of a query expression (also another place where you could build an expression to find your answer.