There are two options for doing this:
1) You can use an OR operator in your IF statement to check for multiple conditions such as in this example (the underscore after the OR is to allow the statement to use multple rows).
Sub Bug_FieldChange(FieldName)
On Error Resume Next
If FieldName= ''BG_STATUS'' Then
If Bug_Fields.Field(''BG_STATUS'').value= ''Ready for Testing'' OR _
Bug_Fields.Field(''BG_STATUS'').value= ''Rejected'' OR _
Bug_Fields.Field(''BG_STATUS'').value= ''Requirements Review'' OR _
Bug_Fields.Field(''BG_STATUS'').value= ''SME verification''
Then
Bug_Fields(''BG_USER_05'').IsRequired=True
Else
Bug_Fields(''BG_USER_05'').IsRequired=False
End If
End If
End Sub
2) You can build this into a Select statement instead. This would be useful if you anticipate adding future conditions.
Sub Bug_FieldChange(FieldName)
On Error Resume Next
If FieldName= ''BG_STATUS'' Then
Select Bug_Fields.Field(''BG_STATUS'').value
Case ''Ready for Testing''
Bug_Fields.Field(''BG_USER_05'').IsRequired=True
Case ''Rejected''
Bug_Fields.Field(''BG_USER_05'').IsRequired=True
Case ''Requirements Review''
Bug_Fields.Field(''BG_USER_05'').IsRequired=True
Case ''SME verification''
Bug_Fields.Field(''BG_USER_05'').IsRequired=True
End Select
End If
End Sub