Hey guys once again, anyone's assistance would be greatly appreciated.
I have a subform (in Continous form view) based on a table with fields like this:
tblTwo
-------------
EquipId
Issued
IssuedTo
IssueDate
RequisitionNo
Returned( THIS IS A CHECKBOX)
ReturnDate
ConditionOf Equip
etc, etc,
Now I wanted the the [ReturnedDate] field and the [ConditionOfEquip] to only be enabled if the checkBox was ticked. I got that working fine by using the afterupdate propertyof the [Returned] field but the problem is:
Since I am in continous view, all the [ReturnedDate] fields and the [ConditionOf Equip] fields in the other previous records also become enabled or dis-abled (ie the same field in the other records that I am not presently editing become enabled or dis-abled when I click and unclick the checkbox)
I want to be able to only affect the enabled property of the [ReturnedDate] and [ConditionOfEquip] fields for the RECORD I am EDITING. But I need the form to be in continous view becasue the user needs to see the previous entries for that EquipId.
Please help if you can.
ZaZa
I have a subform (in Continous form view) based on a table with fields like this:
tblTwo
-------------
EquipId
Issued
IssuedTo
IssueDate
RequisitionNo
Returned( THIS IS A CHECKBOX)
ReturnDate
ConditionOf Equip
etc, etc,
Now I wanted the the [ReturnedDate] field and the [ConditionOfEquip] to only be enabled if the checkBox was ticked. I got that working fine by using the afterupdate propertyof the [Returned] field but the problem is:
Since I am in continous view, all the [ReturnedDate] fields and the [ConditionOf Equip] fields in the other previous records also become enabled or dis-abled (ie the same field in the other records that I am not presently editing become enabled or dis-abled when I click and unclick the checkbox)
I want to be able to only affect the enabled property of the [ReturnedDate] and [ConditionOfEquip] fields for the RECORD I am EDITING. But I need the form to be in continous view becasue the user needs to see the previous entries for that EquipId.
Please help if you can.
ZaZa