Hi,

I would like to populate an unbound field in the report when the report opens. But the report will not display a value when it opens up. Why?

Private Sub Report_Open(Cancel As Integer)
str = "SELECT sum(qty_received) as qty FROM dbo.tblFinal_inspection"
Me.RecordSource = str
End Sub

Thanks!