IIf Formula returning wrong result and thus a false error

[RunTime91]

Greetings Everyone...

Not sure why this IIf is calculating the 'False' part

Here is how it is written:

PctSavings = IIf(Me.CmbDept = "Store Discount", 1, (TtlSavings / Me.TxtRegPriceTtl))

Me.CmbDept does equal "Store Discount" and thus I'm looking for the return of 100% in the PctSavings control and the subsequent table field name
however the formula is blowing past the True part and calculating the false part and giving a Div/0 Error. (The values of TtlSavings & Me.TxtRegPriceTtl are $7.50 and 0 respectively)

Looking forward to reading is staring me right in the face but I'm just too blind to see it...

Thank You All ~

RT91

[mike60smart]

Hi

Are the Data Types of TtlSavings = Currency and TxtRegPriceTtl = Numeric ?

[Gicu]

Could it be that the combo is displaying "Store Discount" but the actual bound column is hidden and maybe has a different value (numeric ID usually)?

Cheers,

[Welshgasman]

Greetings Everyone...

Not sure why this IIf is calculating the 'False' part

Here is how it is written:

[code]
PctSavings = IIf(Me.CmbDept = "Store Discount", 1, (TtlSavings / Me.TxtRegPriceTtl))

Me.CmbDept does equal "Store Discount" and thus I'm looking for the return of 100% in the PctSavings control and the subsequent table field name
however the formula is blowing past the True part and calculating the false part and giving a Div/0 Error. (The values of TtlSavings & Me.TxtRegPriceTtl are $7.50 and 0 respectively)

Looking forward to reading is staring me right in the face but I'm just too blind to see it...

Thank You All ~

RT91

Is CmbDept a lookup field?

[Micron]

Not sure why this IIf is calculating the 'False' part

All parts of that function are evaluated. It does not stop just because the first one might be true.
EDIT - I didn't post that as a solution but to let you know that both parts are evaluated because it seems you didn't realize that. Have to say though, I've never really understood the significance of it.

[RunTime91]

Hey Mike ~

Checked and both controls are set to Currency - 2 decimals.

[RunTime91]

Hey Gicu...

I'm using a single field table for the row source on that particular combo. the bound column is set to 1 if I set it to 0 I get the numeric ID you mentioned)
When I step through the code and hover over the CmbDept it gives back "Store Discount" so (I think) that is good to go.

[RunTime91]

Welshgasman ~

I'm gonna let you educate me on this one.

I believe the answer is no...

The ComboBox is populated using a query with a single table as the source.

My understanding of a lookup field is different than that... but I'm light on knowledge with that so if I'm wrong I'm ready to learn.

[RunTime91]

Hey Micron ~

You are correct Sir ~ That! ~ I did not know...I'm not understanding that either.

Now that I know that however, I think I am going to re-think my approach to that section of code.

I'll try a different approach and post back

Thanks my Brother!

[RunTime91]

Solved ~

To everyone who chimed in on this one ~ Thank You!

As it turns out adding the Column did the trick.

PctSavings = IIf(Me.CmbDept.Column(0) = "Store Discount", 1, (TtlSavings / Me.TxtRegPriceTtl))

Thanks Again to everyone!!

RT91