Combobox dropdown

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Alireza355
    New Member
    • Feb 2009
    • 86

    Combobox dropdown

    Dear all,

    I have a combobox, which shows some records from a query in the combobox rowsource.

    I want the combobox to dropdown whenever it receives focus from the previous field, so that the user becomes familiar with the information that has already been entered by previous users in the past...

    I would appreciate your assistance.

    Thank you so much.
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Put the following code in the "On Enter" event of the combobox

    Code:
    Me.ComboboxName.Dropdown

    Comment

    • MMcCarthy
      Recognized Expert MVP
      • Aug 2006
      • 14387

      #3
      Small change, it might be better to change it to the "Got Focus" event.

      Comment

      • Alireza355
        New Member
        • Feb 2009
        • 86

        #4
        Thanx a lot

        Thanx a lot.

        It worked perfect...

        Best Regards,
        Alireza355

        Comment

        • MMcCarthy
          Recognized Expert MVP
          • Aug 2006
          • 14387

          #5
          Originally posted by Alireza355
          Thanx a lot.

          It worked perfect...

          Best Regards,
          Alireza355

          You're Welcome :)

          Comment

          Working...