In access 2003 multiply 2 text box display result in 4th Text box based on 3rd Text box condition

Ok First you need to decide how the calculation is going to be trigger. I am going to assume that there is a button that you click to run the calculation. So we will use the onclick event of that button and insert the following code

Private Sub ButtonName_OnClick()

Dim strCondition as string
strCondition=Me.TextBox3

Select Case strCondition

Case condition1

Your calculation

Case Condition 2

your calculation

Case Condition3

Your calculation

End Select

End Sub

Sorry forgot the inverted comma around the cases

Private Sub ButtonName_Click()

Dim strCondition as string
strCondition=Me.TextBox3

Select Case strCondition

Case "condition1"

Your calculation

Case "Condition2"

your calculation

Case "Condition3"

Your calculation

End Select

End Sub

need a little bit more information.

you could set the default of the 4th control to a function or an expression which accepts parameters from the first three textboxes.

= (NZ(me.[Field1], 0) + NZ(me.[Field2], 0) + NZ(me.[Field3], 0)

But without knowing more about the values in first two textboxes, a better explaination of what is in the third, and how these relate to textbox 4, we cannot provide much help.

I used iif solution for the above condition

I've requested that this question be closed as follows:

Accepted answer: 0 points for venkatramreddy_g's comment http:/Q_27029623.html#36094743

for the following reason:

I used IIF Solution for my problem

I slightly modified and used the IIF solution and result is stisfactory

I couldnt assign the CASE STATEMENT code to form so I couldnt use this solution otherwise is very good solution

g

> I used iif solution for the above condition

- as I suggested? Or how?

/gustav

http:#a35735442
seems to hold the answer.

/gustav