Check Box selected, disable Form from edit

[vanny]

Hey all,

I have a form called Orders and have a subform called Orders1. Now in the Orders form I have a check box that shows whether the Order is closed or not. So when the Order is closed it will be ticked. (thus status:YES)

What I would like to do is that when Order CHeck Box is YES, both the Form and Subform are Disabled, thus user cannot go into them for editing.

Can someone suggest a way of doing this pls?


Thanks a lot

 

[Oldsoftboss]

In the after update event (and perhaps form_current) Put

me.allowedits = not me.checkboxname
me.subformname.enabled = not me.checkboxname

 

[vanny]

Thanks a lot...

It worked perfectly.

Thanks