Hi Folks,
I have a button on my form which is enabled/disable based on a selection in a combo box. This is the code im using:
Private Sub CCIR_Required_Change()
If Me.CCIR_Required.Column(0) = "YES" Then
Me.Command1176.Enabled = True
Else
Me.Command1176.Enabled = False
End If
However, if i select No then the command button 1176 stays disabled on the form for all other records (even if 'yes' was selected on a previous record). How can i have this functionality based on the current record? Do i need to reference the records PK?
Many thanks!
I have a button on my form which is enabled/disable based on a selection in a combo box. This is the code im using:
Private Sub CCIR_Required_Change()
If Me.CCIR_Required.Column(0) = "YES" Then
Me.Command1176.Enabled = True
Else
Me.Command1176.Enabled = False
End If
However, if i select No then the command button 1176 stays disabled on the form for all other records (even if 'yes' was selected on a previous record). How can i have this functionality based on the current record? Do i need to reference the records PK?
Many thanks!