triggering an even based on a date

[genxiii]

hey guys, hope you can help with this problem i'm having.

i have a table with a couple of records with a check box field called "ongoing." When this is checked, the record is to be carried over to the next year. I have to make a duplicate of the record for historical purposes though. is there a way i can right a VBA event procedure that is triggered automatically by the date? by the date of the end of a fiscal year i want it to copy all of those records with "Ongoing" checked and have their year field changed to the new year.

 

[MIKElaw]

If the form ever closes, which I am sure that it will at sometime during a week even if only to allow the backup free access, then you can have a VBA routine in the 'On Open' event which checks the date and then either does something or does nothing.

If the form never closes then the 'On Timer' event might does the trick


Hope this helps


Mike