Unanswered: Help with writing code for an event procedure in Access 2003
I am using Access 2003 and I have a form that has a staus combo box and a resolution_eta box. When I choose close from the status box, I want the current date and time to go into the resolution_eta box. I have written some of the code but it's not working. I'm still learning how to write the code.
The code I have written is:
Private Sub Status_Change()
If Me![Status] = "Closed" Then
Me![Resolution_ETA] = Now()
The error is on the second line
I have also put date instead of now but that also gives me an error.
Can anybody help please.
Last edited by kathhear; 10-12-09 at 20:19.
Reason: I didn't put enough information in.