Combo Box and a newbie

[Guest]

1. How can I update the contents of a combo box without going into design
every time.
2. And when inputing data how is the required item chosen.

 

[Wayne Morgan]

1) You need to have a table with a listing of the data. For an example, open
the Northwind sample database that comes with Access. The Products form has
two combo boxes that draw their data from a table.

2) a. You can type into the combo box. If the combo box's AutoExpand
property is set to Yes, it will try to match the letters as you type with
the first item in the list that matches.

b. You can use the mouse to open the drop down and click on the desired
selection.

c. You can use Alt+Down Arrow to open the drop down, use the up and down
arrows to navigate the list, and press Enter or Tab to make the selection.