Results 1 to 4 of 4
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919

    Perplexing Combo Box Dropdown issue

    The snipit of code below is taken from the midst of a VBA Select Case within the "On Click" event for the combo box "Combo33". On the corresponding form, there are two combo boxes superimposed, Combo33 and cboMonths. One of the list items on the Combo33 dropdown is case 9010. When that item is selected, the intent is to switch the visibility of the two combo boxes and automatically dropdown the combo box "cboMonths". The statement "Me.cboMonths.Dropdown" you see isn't having any effect.

    What might I be missing?

    (BTW, the On Click event for cboMonths toggles the focus and visibility back to the nominal state for the form.)

    Code:
    Case 9010 ' Birthdays
    Me.cboMonths.Visible = True
    Me.cboMonths.SetFocus
    Me.cboMonths.Dropdown
    Me.Combo33 = ""
    Me.Combo33.Visible = False
    Exit Sub


  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,412
    not tested but try

    Me.cboMonths.Dropdown=True

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919
    It appears that the "After Update" event for Combo33 is causing the issue. I'll post back as soon as I sort that out.

  4. #4
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919
    I found it. The "After Update" event code for Combo33 had a path that could cause a Requery of the form's Recordset which shifted the focus to the first record.

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

Similar Threads

  1. Dropdown Event on a Combo Box?
    By Paul H in forum Forms
    Replies: 4
    Last Post: 10-05-2015, 11:45 AM
  2. Perplexing forms issue
    By Wildanessdude in forum Programming
    Replies: 9
    Last Post: 02-06-2013, 07:58 AM
  3. Replies: 8
    Last Post: 10-22-2012, 01:24 PM
  4. Combo box dropdown style
    By desk4tbc in forum Programming
    Replies: 4
    Last Post: 10-05-2011, 05:55 PM
  5. Minimizing combo dropdown on click
    By DanW in forum Forms
    Replies: 2
    Last Post: 11-18-2009, 03:33 PM

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