If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Set subform record enable/no enabled
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 |
#2
|
|||
|
|||
Set subform record enable/no enabled
On Thu, 4 Feb 2010 14:02:32 -0000, "EddWood"
wrote: 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 |
#3
|
|||
|
|||
Set subform record enable/no enabled
Hi Tom,
Many thanks for that, worked perfectly, thank you "Tom van Stiphout" wrote in message ... On Thu, 4 Feb 2010 14:02:32 -0000, "EddWood" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|