S
Stella P via AccessMonster.com
L.S.
I have a form with 2 subforms.
On subform2 there is a field which has as default date().
On subform1 there is a field with the "due date" of the product.
The "default date", which is todays date when opening the form, has to be
checked against the "due date".
If "default date" > than "due date" the field "due date" has to change of
background color and blink and a message box has to appear saying that
"Default date is > than due date".
How can I have "default date" (date() ) check against "due date"?
I have the coding in the beforeupdate event in the field "default date", but
it only works if I enter the "default date" manually.
And how can I have the cursor on the field "default date" if this field >
than "due date".
I've tried using SetFocus but I keep on getting an error.
Thanks in advance for your help.
Stella
I have a form with 2 subforms.
On subform2 there is a field which has as default date().
On subform1 there is a field with the "due date" of the product.
The "default date", which is todays date when opening the form, has to be
checked against the "due date".
If "default date" > than "due date" the field "due date" has to change of
background color and blink and a message box has to appear saying that
"Default date is > than due date".
How can I have "default date" (date() ) check against "due date"?
I have the coding in the beforeupdate event in the field "default date", but
it only works if I enter the "default date" manually.
And how can I have the cursor on the field "default date" if this field >
than "due date".
I've tried using SetFocus but I keep on getting an error.
Thanks in advance for your help.
Stella