Neobeowulf
Registered User.
- Local time
- Today, 17:42
- Joined
- May 31, 2012
- Messages
- 34
Team,
I'm putting a form together that will have 2 unbound text boxes that show a weekly item total and an item total.
I have a subform for user input. It has 5 columns for the user to input the number of each item given away, [Uniform Items], [Toys], [Household Items], [Clothing Items], [Date Entered].
My weekly filter is working on the subform, but how do I pull a filtered total to put in the unbound text box? I tried to do a totals query, but that locks the record!
I'm putting a form together that will have 2 unbound text boxes that show a weekly item total and an item total.
I have a subform for user input. It has 5 columns for the user to input the number of each item given away, [Uniform Items], [Toys], [Household Items], [Clothing Items], [Date Entered].
My weekly filter is working on the subform, but how do I pull a filtered total to put in the unbound text box? I tried to do a totals query, but that locks the record!
