Solved Msgbox display (1 Viewer)

[Rania01]

My form contains a text box and a combo box.
I would like only When a value is selected from the combo box I want it to be displayed msgbox "Date Entry Required" if in the text box (Date) is empty.
The combo box contains a list I would greatly appreciate help on this.
Thanks in advance

 

[Gasman]

Use the BeforeUpdate eevent of the form to check you have required values.
I personally would swap the position of your controls.
Makes little sense to me to get to a control, only for find I should have completed a previous control?

 

[Rania01]

Dear Gasman,

Could you please help, You can check my file

Thank you

 

[Gasman]

Something along the lines of

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Len(Me.cboFeedback & "") > 0 And Me.cboFeedback <> "No FeedBack" Then
    If Len(Me.txtDate & "") = 0 Then
        MsgBox "Date mandatory if Feedback supplied"
        Cancel = True
    End If
End If
    
End Sub

 

[moke123]

If the date they need to select is usually the current date you could set a default date for the control.
You also should not use Date as a field name as it is a reserved word.

 

[arnelgp]

here are some "suggestions".
see the codes on your form.

 

[Rania01]

Dear arnelgp,

This is what i'm looking for, is working

@Gasman your VBA also work,

Thank you for all of your help and support

​