Allow Read or Update dep on record

[AndreT]

I have a subform in a form, the subform is a datasheet based on a query, one of it's field is a userid field tracking who created the record.

User wants the ability to update records they created, and read only records created by others.

My intention is to make the form enabled or disabled depending on which record gets the focus.

First I tried <On Current> event of the subform, got error 2164 - "You can't disable a control while it has the focus."

Next I tried <On Enter> and <Got Focus> event of the subform fields to disable the form, that gave me the same error.

Is what I want to do possible? Your advice is appreciated.

[pbaldy]

The current event is the place for the code. I'd set the allow edits property of the form, rather than disabling it.

[AndreT]

Thanks Paul. That should work. I'll give it a try.