A
Anna
I create two fields in my old table. One is D_Status of type Yes/No
Checkbox and the other is DDate of type Date. In my table there is
already records in it. I set the default value of DDate as Date() (as I
need the current date). My problem is when user open the form and click
on D_Status in any old record, The record is not updated with the
current date. But when user enter the new record its save with the
current Date. My question is how to i update the old records on the
basis of D_Status if user click (Dstatus) on old record it must be
update field DDate with the current date needs help.
Thank You.
Checkbox and the other is DDate of type Date. In my table there is
already records in it. I set the default value of DDate as Date() (as I
need the current date). My problem is when user open the form and click
on D_Status in any old record, The record is not updated with the
current date. But when user enter the new record its save with the
current Date. My question is how to i update the old records on the
basis of D_Status if user click (Dstatus) on old record it must be
update field DDate with the current date needs help.
Thank You.