Results 1 to 2 of 2
  1. #1
    cowboy is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2010
    Posts
    291

    Macro for Me.ActiveControl.Dropdown


    Is there a macro that can do the same thing has the code:
    Code:
    Private Sub cmbSetArea_MouseUp(Button As Integer, Shift As Integer, x As Single, y As Single)
        Me.ActiveControl.Dropdown
    End Sub
    So I don't have to have my vba with a lot of extra sub routines?
    For those that are not familiar, this is for when someone clicks on the combobox and not the arrow next to the combobox and it still brings up the dropdown list.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    I dont know what you're trying to do with the combo here....BUT

    when the user picks an item in the combo box, you normally put code in the COMBO_AFTERUPDATE() event

    if you want to assign something to it you just say, cboBox = "Value"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 09-16-2014, 03:56 PM
  2. Replies: 1
    Last Post: 07-09-2014, 03:36 PM
  3. Usage of Screen.Activeform.ActiveControl - syntax
    By dcdimon in forum Programming
    Replies: 6
    Last Post: 06-17-2014, 09:05 AM
  4. ActiveControl form Events - VBA
    By Epidural in forum Forms
    Replies: 5
    Last Post: 05-22-2012, 10:44 AM
  5. Help with gotocontrol, activecontrol
    By k9drh in forum Forms
    Replies: 5
    Last Post: 04-21-2011, 10:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums