This code is not doing anything. I am trying to identify Fields that the user must enter data by making the field border red is the field is Null or "".
Private Sub Form_Activate()
'Check to see if PID is set to "Select-A-PID"
If Me.RFPMgr_ID = 1 Then
DoCmd.OpenForm...