Hi again all.
Thank you very much for all the help so far! Still struggling with making my database perfect - so close though!
I am trying a bit of basic code. I don't want forms to be edited after they have been input unless a button that I have labeled 'edit' is pressed. I have got this to work but I want an exception to the editing block. I want two fields called "Booked" and "Appointment Date" to be free to edit until the "Booked" field has been ticked (it is a yes/no box).
This is what I have so far....
Private Sub cmdEdit_Click()
Me.AllowEdits = True
End Sub
Private Sub Form_Current()
If Me.NewRecord Then
Me.AllowEdits = True
Else
Me.AllowEdits = False
End If
End Sub
Any comments/tips/tricks on changing this code in line with the above request would be greatly appreciated!
Thanks again