I'm sorry, I don't know how I could have forgotten to mention it is an Access form.
I made the following changes to the form open event:
Private Sub Form_Open(Cancel As Integer)
Call MyCheckbox_Change
End Sub
And the following changes to the dropodown event:
Sub MyCheckbox_Change()
End...
DeeBeeGee,
You are wonderful to help me out, it is exactly what I wanted. I am unable to get it to work though. Can you help?
I added the following code to the form open:
Private Sub Form_Open(Cancel As Integer)
Call MyCheckbox_Change
End Sub
Then I added your code:
Sub...
I am new to VBA and I am trying to control which items show up in my dropdown box (MyDropdown), based on whether a check box (MyCheckbox) is checked or not. The dropdown box is populated from a table (MyChoices). If the check box is checked, I would like it to list choises 1,2,4, and 8. If it is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.