theinviter
Registered User.
- Local time
- Today, 06:16
- Joined
- Aug 14, 2014
- Messages
- 237
Dear Guys;
i need a help.
i have a form to filter to fill , if user did not select date first and he add any value them , i want msgbox to show text message and cancel the data entered;
i tried this but not working.
Private Sub TOTAL_PHYSICAL_COUNT_AfterUpdate()
If IsNull(Date_From) Then
MsgBox " Please Add Date Range"
Me.TOTAL_PHYSICAL_COUNT.Undo
Else
TRT= Text140
End If
End Sub
i need a help.
i have a form to filter to fill , if user did not select date first and he add any value them , i want msgbox to show text message and cancel the data entered;
i tried this but not working.
Private Sub TOTAL_PHYSICAL_COUNT_AfterUpdate()
If IsNull(Date_From) Then
MsgBox " Please Add Date Range"
Me.TOTAL_PHYSICAL_COUNT.Undo
Else
TRT= Text140
End If
End Sub