ukbusiness
asked on
Total value from combo box selection
I am trying to modify my database to use a combo box for selecting various levels of sponsorship in a tournament. Each level has a value that I need to total in a field. I am certain that the solution is quite simple but I am missing something in my limited Access knowledge.
ASKER
My problem goes deeper than just a requery. I am using a combo box with multiple selections. The combo box is working fine but the table it works off of contains the charge for each item. I am trying to grab the total value of all items selected so that I can show them on a form and place them in a file for invoicing.
TypeID Type Charge
129 1 Player Sponsor $150.00
104 2 Player Sponsor $300.00
105 3 Player Sponsor $450.00
73 Beverage Cart - Sponsor $750.00
87 Breakfast and Lunch Sponsor $600.00
75 Bronze Sponsor $1,000.00
TypeID Type Charge
129 1 Player Sponsor $150.00
104 2 Player Sponsor $300.00
105 3 Player Sponsor $450.00
73 Beverage Cart - Sponsor $750.00
87 Breakfast and Lunch Sponsor $600.00
75 Bronze Sponsor $1,000.00
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Me.Requery or
Me.sfrmName.Requery
sfrName = the name of your subform
The code above will work if the record source of your form/subform is a query where the value of the combo box is used as filter criteria.
Sincerely,
Ed