Board index » VBA

All times are UTC



 When value changes, update other field with current date 
Author Message
Garr
#1 / 1
 When value changes, update other field with current date

I have created two fields, Status (text) and Status Date
(date). I have put a formula in the Status field to change
based upon input of start and finish dates, actual start
and finish dates, etc. My users would like the Status Date
field to reflect the date that the Status field changed
statuses. Could anyone provide example code on how to do
this? Much appreciated.


Sun, 26 Sep 2004 21:46:37 GMT  
 
 Page 1 of 1
  [ 1 post ] 

 Relevant Pages 

1. Changing a Calculate field (Date) depending on Current date

2. Updating Calculated field depending on Current Date

3. Update a DATE-field to a NULL-value

4. Variable and field value changes after .Update in VBA

5. Update field in record with last date changed

6. Null date values in Date/Time fields in Access DB

7. How do you update a null date into an access table date field

8. Want to auto update date field based on adding check in another field

9. Calulated fields changes control values back to original values

10. COMBOBOX.BOUNDTEXT VALUE CHANGES TO DIFFERENT FIELD VALUE

11. ?? How to set DTPicker Value to current date??

12. how do you get a current record field value from a dataset

  

 
Powered by phpBB® Forum Software