Check Box VBA code in a form

[alirezamb]

Hi friends,
I am trying to create form.
I have a check box in my form with the name ChkDone.
I am going to write code for this check box and link it with some fields in my form.
The plan is if the check box is true or yes those fields will be available to insert data and if not they will be disabled.
Please help me for this issue.


your kind will be appritiated

[darshit_goswami]

here it goes...

say u have a checkbox named as chkVehicle and you want a field depend on whether to enable or disable it based on checkbox value.

Private Sub chkVehicle_Click()
If Me.chkVehicle.Value = True Then

Me.VehicleNo.Enabled = True

Else
    Me.VehicleNo.Value = ""
    Me.VehicleNo.Enabled = False
End If


End Sub

hope this helps

[alirezamb]

Thank so much for your help
but it didn't work.
I think because of that my form type is as list.
could you please let me know if it works with list form or not

[ssanfu]

....but it didn't work.

What didn't work? Be specific.

Did you change "VehicleNo" to the name of one of your controls?

I think because of that my form type is as list.

Do you mean the form is in continuous forms view? Or you have a list box on the form?
If the form is in continuous forms view, locking/disabling a control disables that control for all records.


You could post your dB for evaluation......