Search results

  1. S

    I used the following code: If Me.Status = "Archived" Then If IsNull(Me.Archived_Date) Then...

    I used the following code: If Me.Status = "Archived" Then If IsNull(Me.Archived_Date) Then MsgBox "You must enter a date when the Status is Archived.", vbOKOnly Cancel = True End If End If
    • shenekas
    • Profile post comment
  2. S

    I would like to make the Archived Date field a "required" field if the Archived value is...

    I would like to make the Archived Date field a "required" field if the Archived value is selected in the Status field in Access 2016. Is there anyway to have the cursor automatically go to the Archived Date field so that the date can be selected? Does you have any idea how to fix this?
  3. S

    Make a field required based on another field

    I'm not sure either. I tried that, but then I receive this error.
  4. S

    Make a field required based on another field

    My apologies. I’m not as well versed in the language as most probably are. But yes, it is in the form’s BeforeUpdate event.
  5. S

    Make a field required based on another field

    In the form properties. I have it as an event procedure on that field.
  6. S

    Make a field required based on another field

    Hello, I have a source table in Access 2016. This table has a field called Status and a field called Archived Date. The Status field is a Lookup field with 2 Values: Active and Archived. I would like to make the Archived Date field a "required" field if the Archived value is selected in the...
Top Bottom