Version: Access 2010
I have the below on a form to see the total of the subform.
It works fine on my computer and I've used the similar on forms - reading of subform values on multiple different applications at multiple clients in the past. The worst that has ever happened - It took 3 to 5 seconds to populate.
I have the appropriate indexes.
The current client (Hospital - can't change anything on the machine) just sits there for a full minute and it doesn't populate.
They have the exact same problem if I try to read from a query
=DSum("[Amount_Owed]","qry_Clients_Invoice","[ClientIdd] = [txt_Id_Number]")
I can solve the problem, my question is mainly has anyone seen this happening and know why? Is it low memory? Is it we are close to holloween? :)
I can solve the problem
I can solve the problem by using a dao recordset - run the code and populate the field.
1) I like just reading the control on the subform because if the user is moving through 30 records, Access doesn't slow things down to figure the value.
2) I always want a better understanding of WHY something happens I didn't expect (Why the above is not populating). It makes me a better programmer.
Just to repeat - It's a Hospital - can't change anything on the machine - Only changes can be in my database.