If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update old record date when user click on D_Status
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. |
#2
|
|||
|
|||
Update old record date when user click on D_Status
On 27 Aug 2006 16:39:32 -0700, Anna wrote:
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. Answered elsewhere. Please do not multi-post. If you feel you must post the same question to more than one newsgroup (and it's seldom necessary), cross-post by adding each additional newsgroup in the To Newsgroups: box, separated by a comma. This way an answer in one newsgroup will be seen in each of the others. More readers will see the response and learn, and less time will be spent on duplicate answers. See Netiquette at http://www.mvps.org/access It's a great site to visit anyway. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|