Required field

[Jagged]

Hi


Anyone have a solution for this?

I have a form with a combobox on it with 9 different possible outcoms. What I want to achieve is that if the user has selected one of 3 specific outcomes then there is another field on the form that is required. If none of them has been selected then the field isn't required.

How do set up the check for the specific value?

 

[CJ_London]

see this link which is on the same subject - you'll find the code in post #36

http://www.access-programmers.co.uk/forums/showthread.php?p=1313817#post1313817

 

[pr2-eugin]

Use the Form Before Update event..

Private Sub Form_BeforeUpdate(Cancel As Integer)
    If Me.[COLOR=Blue]yourComboBoxName[/COLOR].ListIndex <> -1 Then
        Select Case Me.[COLOR=Blue]yourComboBoxName[/COLOR]
            Case "[COLOR=Red]Option 1[/COLOR]", "[COLOR=Red]Option 2[/COLOR]", "[COLOR=Red]Option 3[/COLOR]"
                If Len(Me.[COLOR=Blue]theRequiredControlName [/COLOR]& vbNullString) = 0 Then
                    MsgBox "This is a Requierd value, as you have selected " & Me.[COLOR=Blue]yourComboBoxName[/COLOR], vbCritical, "Please Retry"
                    Me.[COLOR=Blue]theRequiredControlName[/COLOR].SetFocus
                    Cancel = True
                End If
        End Select
    End If
End Sub

Change names to match your design.