Dear Access Master,
I have a subform and I want to calculate total number of records in that subform. Therefore I use domain aggregate Count(*) below subform. Do you think, it is good idea ? I am just worried that it will slow in speed when open the form with that subform inside. If it's slow, do you have other alternative ?
Because I read on internet tips that DA (domain aggregate) will slow, because it will fetch all records eventhough I just need one value.
Previous thread I saw that it won't affect the speed in form with VBA code inside the form. What I ask, does it effect by using DA on form ?
Thanks a lot for your help.
regards,
Tio