Sum of Cascading Combo Boxes

[alonewolf23]

I have created a form with Cascading Combo boxes. The first Combo boxes Populates for text boxes using

ComboBox 1:

SELECT CPU.CpuSupplierName, CPU.CpuModel, CPU.CpuCores, CPU.CpuSpdGHz, CPU.CpuPrice, CPU.CpuSocket FROM CPU ORDER BY CPU.CpuSpdGHz;

TextBox Fills:

=[ComboCpuSuppName].[column](1)
=[ComboCpuSuppName].[column](2)
=[ComboCpuSuppName].[column](3)
=FormatCurrency([ComboCpuSuppName].[column](4))

Combox 2:



SELECT Motherboards.MoboSupplierName, Motherboards.MoboModel, Motherboards.MoboPrice, Motherboards.MoboSocket FROM Motherboards WHERE (((Motherboards.MoboSocket)=[txtCpuSocket]));

Text Boxes Fills:

=[ComboMoboSupplier].[Column](1)
=FormatCurrency([ComboMoboSupplier].[Column](2))
=[ComboMoboSupplier].[Column](3)

So the first combo box Is CPU's, The second combo box is restricted only to list the Motherboards that will work with the desired CPU. They work and poulate. I would like to then Add the Two Prices to show a Sum of the Selected combinations. I have tried to sum them in Query which works, then pull that Query Exp. into my Form, but that gives me a #Name?. and i would rather just sum it in the form. Is it possible to Sum
Cascading Combo Box Values.

=Nz([ComboCpuSuppName].[Column](4),0)+Nz([ComboMoboSupplier].[Column](2),0).

I picked that code up somewhere, and it half works. it shows "PricePrice" but does not add them.

[June7]

I presume PricePrice is alias for the actual number values.

I just tested this and it is concatenating the values. This is because + is old BASIC operator for concatenation as well as sum operator. Use Val function to force Access to recoginze the values as numbers instead of strings.
=Val(Nz([ComboCpuSuppName].[Column](4),0))+Val(Nz([ComboMoboSupplier].[Column](2),0))

I have encountered this in expressions in Access controls before. VBA will also concatenate two values if they are both defined as strings, even if they are only number characters.

[alonewolf23]

Thank you for you help. It solved my issue, and no i can go and create some more!