Changing the “required” property according to value in another field

Topic

New Reply

I would like to set the “required” property in Field One (Text) of an Access table to True if Field Two (Date) has a value. Any hints to get me started, please?

Reply | Quote

Replies

G,

You could use something like this in the date field (text4) in the example.

Code:

Option Compare Database
Option Explicit

Private Sub Text4_LostFocus()
    If (Not IsNull(Me.Text4.Value)) And _
       IsNull(Me.Text0.Value) Then
         MsgBox "Field1 is Required", _
                vbOKOnly + vbCritical, _
                "Error: Required data missing"
       Me.Text0.SetFocus
    End If
     
    
End Sub

You would use similar code Lost_Focus event in Field1. HTH :cheers:
34392-AccessReqField

Update: I forgot to mention that you could do date specific testing instead of just checking for an empty field.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Perfect! My problem is resolved, as usual.

Thank you.

Reply | Quote