subreport not printing values

[access83]

Hi All,

On my report, I have a subreport. When I preview the report some values in the subreport are not displaying. The recordset of the subreport is a pass through query. I have a total on the subreports footer with the total of a column returned from the pass through query. I calculate this in vba with values from the subreports recordset and assign the value to a textbox on the subreports onload event. When I open the subreport on it's own it displays fine but when i open the report that contains this subreport, the textbox in the subreport is empty.

Does anyone know why this is?

Thanks in advance

 

[Trevor G]

Can you post a sample of the database stripping down any sensitive data, as it would help, what VBA are you using and how are the 2 reports linked, Linked Master and Linked Child

 

[boblarson]

Can you post a sample of the database

Probably not going to help as there is at least one major part of this problem in SQL Server (remember, they said PASS THROUGH QUERY).

 

[Trevor G]

Oops, yes Bob....

 

[vbaInet]

Assign the values to variables and from the variables set the value of the textbox.