Set subform record enable/no enabled

  • Thread starter Thread starter EddWood
  • Start date Start date
E

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
 
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 Tom,

Many thanks for that, worked perfectly, thank you

Tom van Stiphout said:
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
Click to expand...
Click to expand...
 
Back
Top