Show Button & Combo when criteria is selected

[mykal66]

I've never used access before so this is my first attempt at creating a database and and need an additional combo box and button to appear on a form only if the 'Declined' Option is selected. I've looked on the forums and got some code i thought would work but it doesn't



This is the code i have tried.

Private Sub Reject()

    If Me.CboStatus = "Declined" Then
        Me.CmbLetter.Visible = True
        Me.CmdLetter.Visible = True
    Else
        Me.CmbLetter.Visible = False
        Me.CmdLetter.Visible = False
    End If
    
End Sub

Can anyone help please and point me in direction of what I've done wrong?

[alansidman]

Instead of making this a Private sub event, put the code in the after update event for the control cboStatus and in the on load event for the form.

Alan

[mykal66]

Instead of making this a Private sub event, put the code in the after update event for the control cboStatus and in the on load event for the form.

Alan

Thanks Alan, works great now. Much appreaciated

Barry