Posted 16 April 2012 - 09:42 PM
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
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.