Updting a field based on another field

[laotzu]

I'm really new to Access and I have a very basic question. Basically, I have one field that stores a number value, and another field that stores yes/no. I want to yes/no field to update to yes automatically when the number field exceeds 10.



Do I use a query to do this or what? I am completely lost.

[Evgeny]

Hey mate, im not an expert but this vba code should work for you (hit tab after you enter the value)

Private Sub Number_AfterUpdate()

If Me.Number.Value > = 10 Then
Me.Status = "Yes"
Else
Me.Status = "No"

DoCmd.Requery
Me.Refresh

End If
End Sub

Place it in your first field AfterUpdate code.

[Evgeny]

It worked when i tested it, please post if it helped you.
Regards

[RuralGuy]

You really should not store a calculated value in this case. Just use a query to create the yes/no results you need every time.

[Evgeny]

Oh ok... just trying to help with what i know What would be an example of the query?

Regards

[RuralGuy]

Something like:
SELECT NumField, IIF( [NumField] > 10, "Yes", "No") As OtherField

[Evgeny]

is it preferred or the right way of doing it?

[RuralGuy]

This link should help answer that question: http://allenbrowne.com/casu-14.html