Controlling edit

Hi

How can I programmatically block edits on a form and all its sub forms? I
have tried me.AllowEdits = False but it only blocks edits on the main form
and not on any of the sub forms on the main form.

Thanks

Regards

re: Controlling edit

John wrote:[color=blue]
> Hi
>
> How can I programmatically block edits on a form and all its sub forms? I
> have tried me.AllowEdits = False but it only blocks edits on the main form
> and not on any of the sub forms on the main form.
>
> Thanks
>
> Regards[/color]

You have to do the same thing for all the subforms.

re: Controlling edit

Sorry, I should have been clearer. The sub form only has a tab control on it
and then each tab in turn has a sub form on it. I am trying to block one of
the sub forms on the tab control, so I have tried this;

Forms![Main]![SubForm1].Form![SubSubForm1].Form.AllowEdits = False

But this has not worked. Any ideas?

Thanks

Regards

<pietlinden@hotmail.com> wrote in message
news:1150515532.709993.134170@h76g2000cwa.googlegr oups.com...[color=blue]
>
> John wrote:[color=green]
>> Hi
>>
>> How can I programmatically block edits on a form and all its sub forms? I
>> have tried me.AllowEdits = False but it only blocks edits on the main
>> form
>> and not on any of the sub forms on the main form.
>>
>> Thanks
>>
>> Regards[/color]
>
> You have to do the same thing for all the subforms.
>[/color]

re: Controlling edit

Read this and try it out...

http://www.mvps.org/access/forms/frm0025.htm