Set subform record enable/no enabled

[EddWood]

Hi Guys,

I have a subform bound to a query. As part of that query is a checkbox,
[chkSelect] to allow users to select or de-select items on the subform, what
I am looking to do is, if the checkbox is selected I want the record to be
set as enabled = no if the record is not selected I want enabled = yes

The subform is layout out as a form not datasheet.

Thanks

 

[Tom van Stiphout]

On Thu, 4 Feb 2010 14:02:32 -0000, "EddWood"

Try this: in the Form_Current event write:
Me.AllowEdits = Not Me!chkSelect

-Tom.
Microsoft Access MVP

 

[EddWood]

Hi Tom,

Many thanks for that, worked perfectly, thank you

On Thu, 4 Feb 2010 14:02:32 -0000, "EddWood"

Try this: in the Form_Current event write:
Me.AllowEdits = Not Me!chkSelect

-Tom.
Microsoft Access MVP

Hi Guys,

I have a subform bound to a query. As part of that query is a checkbox,
[chkSelect] to allow users to select or de-select items on the subform,
what
I am looking to do is, if the checkbox is selected I want the record to be
set as enabled = no if the record is not selected I want enabled = yes

The subform is layout out as a form not datasheet.

Thanks