locked existing records and ability to add new in the same form.

[Homegrownandy]

This is the form I have for "notes" relating to "jobs". Notes are added when dates are changed for example so its important that old notes cant be amended at all. We need to keep track of changes made by our clients. The form works well, the date added is the current date and its un-editable and the site name is generated from the main form (this is a sub form that opens for each specific "Job").

I cant make the actual notes field un-editable because I need users to add new notes. But I want the already existing ones to be locked.

I would like to keep the form as it is and display the older notes (locked), and also have a black space to add new. Is this possible?

Alternatively, Ill create a new form for adding notes and this can be used to view.

Look forward to your replies.

Andy.


Edit - as you see in the picture I went back and deleted the notes from existing.

[Bob Fitz]

I would suggest some code in the forms On Current event to determine if it is a new record and then set the forms Allow Edits property accordingly.

[Homegrownandy]

Thanks for the reply bob, I'm a beginner, would you be able to explain that to me like I'm an idiot?

Where would I put the code?

then disable edits for the whole form or?

If I knew how to do it, it would be done

thanks! andy

[Bob Fitz]

Hi Andy. Try the following code in the On Current event of the form:

If Me.NewRecord = True Then
  Me.AllowEdits = True
Else
  Me.AllowEdits = False
End If

[Homegrownandy]

Brilliant! Now I wait for people to complain they made mistakes in the notes and I have to change them manually

at least the data is secure! Thanks Bob