Re: Subform Count onto main from and Table
Saving aggregate data is usually ill-advised. Just calculate when needed. Why do you need to save to table?
DB 1A is correct way to calculate and display this data. Code (VBA or macro) can save to field on main form. Real trick is figuring out what event to use. But again, advise not to save.
Won't customers have more than one order?
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Last edited by June7; 11-13-2019 at 01:42 PM.