ENABLE a field based another field.

[Xx_TownDawg_xX]

Basically, I'm trying to ENABLE a field based another field.

If Me.Auditor_ID.Value = "LR" Then
        Me.Series_Master.Enabled = True

I'm close, but no cigar. What am I doing wrong?

 

[vbaInet]

Put your code in the After_Update event of the control that the dependent control is based on. Also, put an End If.

By the way, you enable/disable controls, not fields.

 

[Xx_TownDawg_xX]

The event procedure is "after update".. and I added the missing "end if"

Private Sub Auditor_ID_AfterUpdate()
    If Not IsNull(Me.Auditor_ID.Value) Then
        Auditor_ID.DefaultValue = """" & Me.Auditor_ID.Value & """"
    End If
    If Me.Auditor_ID.Value = "LR" Then
        Me.Series_Master.Enabled = True
    End If
End Sub

When I try to compile, it is hanging on Enabled

 

[vbaInet]

Your Auditor control could be a Label and not a text box.

 

[Xx_TownDawg_xX]

Auditor_ID is the combo box. Auditor_ID_Label is the label. (yes I know.. cboAuditor_ID would have been preferred. )

It's got to be simple if I provide you with all the information you need.

 

[Khalid_Afridi]

Your Auditor control could be a Label and not a text box.

This is a reasonable point. change the label to textbox if it is.

 

[Xx_TownDawg_xX]

Well duh.

Private Sub Auditor_ID_AfterUpdate()
    If Not IsNull(Me.Auditor_ID.Value) Then
        Auditor_ID.DefaultValue = """" & Me.Auditor_ID.Value & """"
    End If
    If Me.Auditor_ID.Value = "LR" Then
        Me.cboSeries_Master.Enabled = True
    End If
End Sub

The "Auditor_ID" was all right, it was the "other control." (I was trying to set the ENABLE on the field name, not the control name.)

THANKS GUYS.

 

[Khalid_Afridi]

Your are welcome XxxX