Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DIS-ABLE fields in CONTINOUS form view.

Status
Not open for further replies.

ZaZa

Technical User
Sep 5, 2001
85
US
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top