MsgBox Help

[Harris21]

Hello,

I have a form that need a MsgBox to pop up when the 'BUI' is XOS and the date value 'Text118' is blank, i have used the following code.

 If Me.BUI.Value = "XOS" And Me.Text118.Value = "" Then
MsgBox "This has yet to be sent to TA: Danny/Lee for Approval", vbOKOnly, Reminder
End If

i have used Null, 0 and False for the 'Text118' requirement but nothing works, can anyone help? i'm sure it something very easy and right in front of my face but it starting to annoye me!

Thanks,

Simon

 

[KenHigg]

Here's a little trick:

If (Me.BUI = "XOS") And ((Me.Text118 & "") = "") Then

 

[Harris21]

Great!

Thank worked like a charm!

Thank you!!

Simon

 

[KenHigg]

Glad to help -