can not change data after a date

[jedrtd]

I want to set the data so if the date is < 03/31/05 in a record, you can not change any data in that record, you can look at it but not change it. How would I do this

 

[PHV]

In the Current event procedure of the form:
Me.AllowEdits = (Me![date control] >= #03/31/2005#)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jedrtd]

I need to change it for each month

 

[PHV]

Me.AllowEdits = (Me![date control] >= DateSerial(Year(Now), Month(Now), 0))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jedrtd]

What I would like to be able to do is let who ever closes the data entry for the month to be able to change the date, maybe as part of an end of month process.

 

[jedrtd]

Thank you for the help, got it working made a new field check for empty if so can edit,


if not, no edit