This is my first attempt to use OLE objects on a Form and have some questions.
I have put 2 MS DatePick OLE objects onto my form representing FirstDate and LastDate.
My Control Source for these objects are mdFirstDate and mdLastDate respectively. And setting these variables does successfully initialize the object value when the form is launched.
I need to perform a When and Valid expression on these date values to ensure that the Last is not earlier than the First, etc.
However I do not find When Method or Valid Method within the properties of these objects.
How and/or where do I perform these validation tests?
Additionally I do not see that the control source variables are being set to new values by changes made to the DatePick objects. Why not?
Your advice and suggestions are greatly appreciated.
Thanks,
I_Forgot
I have put 2 MS DatePick OLE objects onto my form representing FirstDate and LastDate.
My Control Source for these objects are mdFirstDate and mdLastDate respectively. And setting these variables does successfully initialize the object value when the form is launched.
I need to perform a When and Valid expression on these date values to ensure that the Last is not earlier than the First, etc.
However I do not find When Method or Valid Method within the properties of these objects.
How and/or where do I perform these validation tests?
Additionally I do not see that the control source variables are being set to new values by changes made to the DatePick objects. Why not?
Your advice and suggestions are greatly appreciated.
Thanks,
I_Forgot
