enable fields on click of a check button

[rockdc1981]

i need help i search the forum but i cant find a thread like this...

i have check box i named isd item?(yes or no)
then i have infos like price, deals, cost, gp, etc below...is it possible that by default the info fields for isd item will be disabled given that the default value for the check box is no and when i check the box the info field will be enabled...

please give me example or link how can i code this...thanks for the help

[nico5038]

The basic approach will be to have code added to the OnClick event like:

IF Me![isd item] = True then
    Me.field1.enabled = true
    Me.field2.enabled = true
    ' etc.
else
    Me.field1.enabled = false
    Me.field2.enabled = false
end if
 

To synchronize the fields for scrolling through records you can add to the OnCurrent event the same lines, or better Call the OnClick event of the checkbox.

Nic;o)

[rockdc1981]

given:
i have a continous form view and i can change to datasheet view
issue #1-on form load the isd info fields are not disabled...when in fact the default value for isd item is no or false
issue # 2-when i select no for [isd item?], the other form isd info becomes disabled when in fact the [isd item?] field is selected as yes

[nico5038]

In a continuous (or datasheet) form this trick won't work. :-(
Access doesn't make difference between the properties of the controls in such a situation.

Personally I add in a situation like this another subform that's in sync with the first subform, but showing all always is a lot easier :-)

Nic;o)

[rockdc1981]

well thanks a lot for the help man..i learned something.God Bless..