Jump to content


Register a free account to unlock additional features at BleepingComputer.com
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.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Access 2007 VBA

  • Please log in to reply
No replies to this topic

#1 Darren De Wilde

Darren De Wilde

  • Members
  • 208 posts
  • Location:Howell, NJ
  • Local time:11:58 PM

Posted 16 April 2012 - 09:42 PM

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,


BC AdBot (Login to Remove)


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users