What are Combo Boxes and how do I create one in Access 2007? A Combo Box is a drop down list of fields found in your table or query. For example, you can create a lookup list that has two parts in it like a Part Number, which is your lookup number, and the description of that Part Number next to it. So that way if a new user hasn't memorized all the Part Numbers of a product, they'll be able to reference that Part Number in the look up Combo Box list and read it's description. Keep in mind that you can choose what value you want stored, which would be the Part Number, because storing descriptions would make the database less efficient or run slower in large database!

Purchase the training video and you can see this in action for yourself!