On Click Event Procedure Problem (1 Viewer)

[jereece]

Attached is a project I am working on. It's a personal reminder program. The problem I am having is that when I enter the actual completion date at the bottom and click on the "Task Completed" button, I want the record to be copied to the History table, then the Start Date and Due Dates reset based on the Frequency. If someone could look at the On Click event procedure for this button and help me get this fixed, I would appreciate it very much. I don't know much about VB or SQL coding.

Thanks,
Jim

 

[Robert88]

Hi Jim,

It seems buttons have been swapped and renamed.

Private Sub [COLOR="Red"]Button96[/COLOR]_Click()
'1.  The record is copied to the "History" table for historical records.
'2.  The Current Due Date changes to the next due date based on the recurring requirement specified
'    (i.e. weekly, monthly, etc.), or if it is "one time", it deletes the record.
'3.  If recurring, the Completed Date field goes blank (because it is reset).

  On Error GoTo [COLOR="magenta"]Button69[/COLOR]_Err........

It seems from your code above which is only part, that the button name has been renamed at some stage to Button96 as all other references refer to Button69, which is through the remainder of the code.

Not sure if that is all but please advise if this fixes the problem.

 

[Robert88]

Sorry slipped with the save, doh!!!

 

[jereece]

Thanks. I was able to get it working properly.

Jim