1.8 Creating a Combo Box in Access

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
62,456
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 28, 2008

Creating an alphabetically sorted combo box search

Category:

Howto & Style

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (17)

Sign In or Sign Up now to post a comment!
  • Yup its helpful

    Thanx

  • @weat010 - sorted: how to get outputs of both combos displayed in a form (Having got second combo to be filtered depending on first combo's selection as per this video)

    After update your second combo box to open a form based on another, new, query: this query has all the fields you want on your form, but in the two fields that your combo boxes are concerned with, add as criteria [Forms]![NameOfFormComboIsIn]!­[NameOfFirstCombo] and the same for the second field,using name of your second combo.

  • Brilliant, but...having created a lovely combo box...how do you get the choice of value in the combo box to deliver the (filtered) results???. eg if the user chooses "single", how do you get a table/ form to appear showing only those results that are single CDs, ie filtered ???

    These are the best videos on access on the web.

  • Thanks a lot!

  • thanks. it helped

  • Great work, truly appreciate the effort, thanks

  • @Firchild

    Ah, okay, only up to 2.13 so far, will watch out for your method when I get to 2.22. Thanks. : )

  • thanks for the tutorials, very fast and efficient, and wales run the rugby... what more could you want!! haha alan in rotterdam

  • @blahdelablah Look at video 2.22, it's all there

  • @yetanotherstatistic

    I've not tried it, but if I was attempting to do as you were I would add an extra field to my CD table, call it something like ImagePath, and store the path to the CD image as a text (for example "C:\CD Images\0101.jpg"), then you should be able to set that image to display when you change the record by playing around in VBA. Hope that helps.

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more