I am trying to create a simple household inventory application. I have an unbound text box on my form that displays the total value of each household category such as appliances, furniture, and so on. I also have a select category combo box that, when updated, sets the form to display only records in the selected category. The code below calculates the total value of a specific category:

txtTotalForSelectedItems = DSum("([Cost] + ([Cost] * [TaxRate]) + [DeliveryCost])", "tblItemInfo", "[Category] = 'Appliances'")

In the code above how do I replace the explicit category name 'Appliances' with whatever the value of the combo box is when it is updated?
I tried:

txtTotalForSelectedItems = DSum("([Cost] + ([Cost] * [TaxRate]) + [DeliveryCost])", "tblItemInfo", "[Category] = cboSelectCategory.Value")

but it won't work. Any help would be greatly appreciated.

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

Thank you. This works. I couldn't quite get the syntax just right.

You're quite welcome. Glad I could help.

Just as a general FYI, when writing criteria for boolean (true/false), numbers, strings, and dates, the syntax requires delimiters for strings and dates.

Boolean & numbers use nothing.

Strings use apostrophes (or "single quotes").

Dates use a pound sign (or number sign or cross-hatch)

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division