allow edits - set to false but actually true - driving me mad!

[mattkorguk]

Hi,
I have all forms set to AllowEdits=False, and an edit button on each form which the user clicks to change this to AllowEdits=True.
Sounds simple enough.
The issue is, the very first record which is displayed, eventhough AllowEdits is switched off, still lets users edit!!

This is driving me bonkers!
Any ideas as to why this might be happening?

Thanks,
Matt

 

[ErikSnoek]

This could be caused by some VBA code changing some of the values on your form. Since it only happens on the very first record, do you have any code in the form open or load events that changes values?

 

[mattkorguk]

Thanks ErikSnoek, that was it!
I have an If statement which updates a field on the form if it meets some criteria, I'll have to find another way round that it would seem.
Thanks again.

 

[georgedwilkinson]

Just turn edits off after that field is updated?

 

[gemma-the-husky]

note that even if you set allowedits = false, you can STILL change anything by code.

 

[mattkorguk]

Gemma - that's what I was hoping. To be able to update the field using code, but users could not update fields until they clicked the 'edit' button. As ErikSnoek pointed out, having the code in place allowed users to update the first record only, so it looked as though the allowedits control was ignored. If I went to the next record allowedits was false and you couldn't edit, but if I went back to the first record you could edit it!
I have now removed the code and added it's function to an existing query, so all is well once more.