Disabled Command Button (1 Viewer)

[melvis]

Hi all,

Thanks to a AWF member last week, I have managed to advance a lot further with the login screen I need but have hit a brick wall.

Below is the code I was given and at present, the code opens up the same form which is fine, but I need the form that opens to enable the delete client button for managers but disable it for clerks.

I was just wondering if anyone could give me some pointers on what code I would need to write to achieve this and where I would need to put this?

Any help would be gratefully appreciated.

Private Sub Command6_Click()

If Me.Password = Me.Combo10.Column(3) Then
     If Combo10.Column(2) = "Manager" Then DoCmd.OpenForm "frm_Splash_Screen"
     If Combo10.Column(2) = "Clerk" Then DoCmd.OpenForm "frm_Splash_Screen"
Else
     MsgBox "Login Error"
End If