Dependent fields 1

[wintergreen]

Is it possible to make one field dependent on another? For instance, I am building a basic contact database and would like to require that either a last name be entered or an organization. If there isn't one or the other or both, I would like an error message to popup and require one of the fields be filled.

Thanks in advance.

 

[Lightning]

Something like this should do the trick

Private Sub MyForm_BeforeUpdate(Cancel as Integer)
    If (IsNull(Me.LastName) OR Me.LastName = "") AND (IsNull(Me.Organization) OR Me.Organization = "") Then
        MsgBox "A Last Name or Organization Name is required",VBOkOnly, "Missing Data"
        Cancel = true
        Me.LastName.SetFocus
    End If
End Sub

Note: I wrote this on the fly, so the syntax may not be exactly correct.


HTH
Lightning

 

[wintergreen]

Thank you! It worked and you have made my day.

 

[willir]

wintergreen

Well give Lighting a star is (s)he made your day.