How to calculate a field based on the value of the other field

[Michelle Anderson]

I have an access form. In the form, it co ntains 3 fields : Type, hours, and Amount.

Field "Type" is a combo box and it contains 2 values: Standard and Rush
Field " Hours" is just a numeric field
Field "Amount" is a currency field.

What I try to do is if the user select Standard from the field "Type", the field "Amount" will be automatically populate by: 24*[hour], else if the type is "Rush" then the Amount field will be as 26*[fhours]

I am not to sure how to start and I would appreciate for any help. Michelle.

[ADezii]

I have an access form. In the form, it co ntains 3 fields : Type, hours, and Amount.

Field "Type" is a combo box and it contains 2 values: Standard and Rush
Field " Hours" is just a numeric field
Field "Amount" is a currency field.

What I try to do is if the user select Standard from the field "Type", the field "Amount" will be automatically populate by: 24*[hour], else if the type is "Rush" then the Amount field will be as 26*[fhours]

I am not to sure how to start and I would appreciate for any help. Michelle.

'This should work nicely:

Private Sub cboType_AfterUpdate()
  Select Case Me![cboType].Value
    Case "Rush"
      Me![txtAmount] = 26 * Me![Hours]
    Case "Standard"
      Me![txtAmount] = 24 * Me![Hours]
    Case Else
  End Select
End Sub

[nico5038]

I nice workaround might be to change your combobox source into a two field valuelist like:
24,"Standard",26,"Rush"
Now also change the number of columns to 2 and set the columnwidth to 0 (zero) as that's suppressing the first column with the 24 and 26.
Also make sure that the bound column is set to 1.

Now the control sorce of field txtAmount can be set to:
=NZ([Type])*[Hours]

Idea ?

Nic;o)

[Michelle Anderson]

Thanks guys . It works wonderfully. Michelle