Hi, I have a calculated field named RemainingStock in a subform called MyItems
When I try to print the values of RemainingStock, it shows an error "Item not found in this collection". But if I try to print any other non-calculated field, everything works fine.
I am using the following code:
Any help please?Code:Dim rs As Recordset Set rs = MyItems.Form.RecordsetClone rs.MoveFirst Do Until rs.EOF MsgBox rs!RemainingStock rs.MoveNext Loop rs.Close