Auto populate field based on another field using after update event

[Xterra14s]

Hello, I'm looking to do the following:

I have four fields involved in this section called: Specialty, consult, Followup, and Urgency. What I'm looking to do is have consult, followup, and urgency update with No, No, Not Urgent when specialty is Xray selected from a drop down. I believe this can be done with a iif event in the after update event for each.



I know how to write it in words but not sure how to do it with code. I want the following: If specialty is "X-ray" then follup is "No". I believe this statement would have to be entered for each of the fields.

Thank you for the help!

[Homegrownandy]

Hi, what are the possible values in the urgency field?

[JoeM]

Use VBA, specifically the AfterUpdate event of the Specialty combo box, i.e.

Private Sub Specialty_AfterUpdate()

    If Me.Specialty = "X-ray" Then
        Me.Consult = "No"
        Me.Followup = "No"
        Me.Urgency = "Not Urgent"
    End If
    
End Sub