Access2007 - adding a date to a memo field

[seepnezorf]

I keep a database of projects. I have a memo field in which I keep dated notes about the status. Above the memo field is a button called "update date." When I click on the button it adds into the memo field a bullet the date and the dash "• 01-07-2008 -"

There is an on click event procedure associated with the button and the code at the back end looks like this:

Private Sub Command73_Click()
Me.Recent_Update = Me.Recent_Update.Value & "• " & Date$ & " - "
End Sub

There is also an event procedure associated with the memo field:
Private Sub Recent_Update_BeforeUpdate(Cancel As Integer)

End Sub

The problem is that once I upgraded to Access2007 I click the button and nothing happens. What do I need to change to get this working again?

thanks,

[missinglinq]

Does any code work? Code does not run in 2007 unless your database resides in a folder that has been declared a “trusted” location.

To trust your folder, click:

Office Button (top left)
Access Options (bottom of dialog)
Trust Center (left)
Trust Center Settings (button)
Trusted Locations (left)
Add new location (button)

Welcome to Bytes!

Linq ;0)>

[seepnezorf]

Hooray! That did it!

Thank you so much!

[missinglinq]

Glad we could help!

Linq ;0)>