<div>
If you create a save button you can do something like this. It depends though, how is your form set up - is it bound or unbound? When do you want the event to execute?<br />

<pre><code id="code-8043052">Private Sub cbSave_Click()

    If Me.tbRequirements.Value = &quot;Other&quot; And IsNull(Me.tbOtherExplanation.Value) Then
        MsgBox &quot;Other explanation required.&quot;, vbCritical
    Else
        DoCmd.Save
    End If
            
End Sub</code></pre>
</div>


If you create a save button you can do something like this. It depends though, how is your form set up - is it bound or unbound? When do you want the event to execute?


Private Sub cbSave_Click()

    If Me.tbRequirements.Value = "Other" And IsNull(Me.tbOtherExplanation.Value) Then
        MsgBox "Other explanation required.", vbCritical
    Else
        DoCmd.Save
    End If
            
End Sub

<div>
<div class="content wysiwyg-content">
I am have a form called APTT and there are two fields - Requirements and Other Explanation. &nbsp;I want to make the &quot;Other Explanation&quot; mandatory if the person selects &quot;Other&quot; in the &quot;Requirements&quot; field. &nbsp;I have little knowledge of VBA but I am learning. &nbsp;How do I do this?
</div>
</div>


I am have a form called APTT and there are two fields - Requirements and Other Explanation.  I want to make the "Other Explanation" mandatory if the person selects "Other" in the "Requirements" field.  I have little knowledge of VBA but I am learning.  How do I do this?

MS Access - Make a field mandatory based on the value of another field in form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.