how to disable certain fields in Form?

[Vaibhav2015]

Hi,


I want to disable certain fields after selecting option from combo box. option are "Yes" and "No". If I select "Yes" all fields must be editable and
If I select"No" only specific two or three fields should be editable.

can you please advice me how I can do that in Access Form.

[ranman256]

set the enabled value by looking at the combo value

sub cboBox_Afterupdate()


txtName.enabled =  cboBox = "Yes"
txtAddr.enabled =  cboBox = "Yes"
txtCity.enabled =  false


txtCode.enabled =  true
end sub

[Vaibhav2015]

Hi,
Can we add If condition in VBA code, for disabled the fields.

[ranman256]

that is the code. What IF do you want?
the combo only has yes/no.

[Vaibhav2015]

Yes. I have added value list "yes","no" in combo box.

[ItsMe]

You can use an If, Then, Else statement to control the flow of statements. For example ...

If Me.ComboName.Value = "Yes" Then
msgbox "You selected YES"
Else
msgbox "You selected NO"
End If

Since you have multiple controls that you want to edit properties for, I would suggest using an If Then Else statement in conjunction with a procedure that looped through all of the controls, identifying predefined controls and updating the properties accordingly.

[Vaibhav2015]

I tried below codes, but after selection 1 or 2 in combo box another text field is still enabled in both If condition.
please advice.

Private Sub Combo0_AfterUpdate()
If Me.Combo0.Value = 1 Then


Me.Text2.Enabled = False


ElseIf Me.Combo0.Value = 2 Then


Me.Text2.Enabled = True
Me.Text2.SetFocus


End If


End Sub

[ItsMe]

You might try inserting a message box to fire when the value of your combo changes. Have the message box display the value of the combo.

msgbox me.combo0.value

If Me.Combo0.Value = 1 Then

 Me.Text2.Enabled = False

 ElseIf Me.Combo0.Value = 2 Then

 Me.Text2.Enabled = True
 Me.Text2.SetFocus

 End If

[June7]

Conditional Formatting can dynamically disable/enable data controls - no VBA needed.