Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.
Hi Everyone,
I am trying to program Access 2007 VBA to make visible an option frame based on the selection in a combo dropdown.
Essentially I need the following to happen;
when a certain selection is made in the comboBox, an option Frame will become visible or another action based on another choice, etc.
I know about the CASE statement but not sure how to code it.
so far I have something like; <where EventType is the current name of the combo box>.
if me.EventType.value = "Call" then
me.frame16.visible = true
end if
This way if the user clicks that an event was a phone call, the options for the result of that call will be displayed.
It seems very simple but I am not experienced and am not sure of what eventhandler to use; AfterUpdate, MouseDown, MouseUp, etc.
Could someone possibly give me an example of what I need to do, where I need to add the code and why. I really want to learn this.
many thanks for all your kind effort and time spent on my question.
many thanks,
Darren
Back to top
