I have not used any message boxes in forms, only validations with inbuilt validation text. This time I want a customised message display without any validation!
I have 2 bound date fields in a table - A and B. The form is bound to a query and a date C is available from another table
When the user enters dates A and B in form, I want it to check date B such B<= A-C-10 and if not, I need a message box to pop up. I dont want any validation
I entered the following code in AfterUpdate of B
If me.B < (me.A - me.C - 10) Then
Msgbox "Check B date entered !"
Endif
I also tried to replace Msgbox with Debug.print
I dont get any syntax error but do not get any message display either
Where am I going wrong?
I have 2 bound date fields in a table - A and B. The form is bound to a query and a date C is available from another table
When the user enters dates A and B in form, I want it to check date B such B<= A-C-10 and if not, I need a message box to pop up. I dont want any validation
I entered the following code in AfterUpdate of B
If me.B < (me.A - me.C - 10) Then
Msgbox "Check B date entered !"
Endif
I also tried to replace Msgbox with Debug.print
I dont get any syntax error but do not get any message display either
Where am I going wrong?