VBA to Disable and Enable Ctrl - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

VBA to Disable and Enable Ctrl

Dan Jackson

4 years ago

Hi,

My status box has an option for referred (#56) and i'm trying to disable controls when selected. The first part works but doesn't re-enable the controls when changed to something else. What am i doing wrong?

==================================

   If [Combo_Status] = 56 Then
        If MsgBox("This will set the record to REFERRED and clear entries in" & vbCrLf & _
        "Advisor, Mortgage Type, Lender, Account Number and Most Figures", vbOKCancel) = vbOK Then
    [Combo_AdvisorID].Enabled = False
    [Combo_AdvisorID].BackColor = RGB(216, 216, 216)
                Else
    [Combo_AdvisorID].Enabled = True
    [Combo_AdvisorID].BackColor = RGB(255, 255, 255)

===================================

It's the else bit that isn't working. It's on After Update for the status combo control

Many Thanks

	Dan Jackson OP @Reply 4 years ago
Just resolved. Was because the else was in the MSGBOX IF, needed to move it down!!!

	Scott Axton @Reply 4 years ago
Look at you! Fixing your own issues. Sometimes just posting it makes you see the errors. LOL Just like I always see my tyoz (err... typos) right after I hit submit.

	Dan Jackson OP @Reply 4 years ago
Gotta love those issues that fix themselves. The amount of times i get called over to fix a computer problem which is fixed by the time i get to the desk!

	Dan Jackson OP @Reply 4 years ago
Just noticed my trekkie badge! Where's my graduation ceremony???

	Richard Rost @Reply 4 years ago
Yeah, it's hard to read your code if it's not properly indented. I know it's a style issue, but it's important. Graduation? Here you go.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View