Calculte Depends on the Type i choose in the combobox

[snirben]

Hi,
i have a form with SubForm and the view is DataSheet.

inside i have 4 TextBox and 1 combobox

1. Amount-Textbox
2. Weight - Textbox
3. Price$ - TextBox
3. Calculte Type- Combobox
4. Total$- Calculeted Textbox

the combobox have 2 options
1. Weight
2. Amount

i want to make the Total$ Textfield to calculte Depends on the Type i choose in the combo box.

if i choose Weight he will do : Price$ * Weight
if i choose Amount he will do : Price$ * Amount

can it be done?
Thank you!

[Seth Schrock]

I would use the Switch() function because it makes it so that you have three tests without nesting functions. So your formula would be something like

Switch([Calculte Type] = 'Weight', [Weight] * [Price$], [Calculte Type] = 'Amount', [Amount] * [Price$], [Calculte Type] Is Null, 0)

Now you can put this as the control source of your Total$ textbox (with a preceding equals sign) or as a calculated field in a query set as the record source for your subform.