How to use a Combo box to display list of commands in ms acces

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mwanaume
    New Member
    • Jul 2015
    • 3

    How to use a Combo box to display list of commands in ms acces

    Is it possible to use a combo box to display a list of commands in ms access? If yes how.
    Thnks in advance
  • jimatqsi
    Moderator Top Contributor
    • Oct 2006
    • 1293

    #2
    Mwanaume,
    Yes it is. Like this. In the data tab of the properties of the combo box (I like using a list box better) you make the source type a value list. Then make the rowset something like this.
    Save;Print;Undo ; ... as many as you need.

    Then in the AfterUpdate event of the list box add a
    Code:
    Select Case me.listboxname
    case "Save"
        ' do save stuff here' 
    case "Print"
       ' do print stuff here
    case "Undo"
       ' do undo stuff here
    end select
    Jim

    Comment

    • Mwanaume
      New Member
      • Jul 2015
      • 3

      #3
      Thanks again. Let me try it out

      Comment

      Working...