No editing after one week

[longshen]

Dear all,

We had used MS Access to create a database.
We have 3 forms that allow people to key in data. Every time after entering the data they will tend to edit it again due to some typo or wrong info. During this editing some people will accidentally edit others data.
We want to prevent people to edit any past data that is more than 1 week old but don’t know how.
We have tried putting an edit button but don’t know what expression or coding to use.
Can we simply use quries to make this work or do we have to create a code for this?
Can anyone kindly help us out?

 

[longshen]

Hi Andrew

The coding is working but i was thinking is there a way to shorten the coding. By using the control properties, Allowedit to set the coding.

for example,

Private Sub Form_Current()
If (Me!Date > Now() - 7) Then

Forms!track.section(acDetail).allowedit = True
Else
Forms!track.section(acDetail).allowedit = False

End If
End Sub

I had try it but it's not working. Where did i go wrong?
Pls Help....