You can update your combo boxes on the fly with the help of an Access shortcut. Mary Ann Richardson explains how it works.
Combo boxes let you type an entry into a field and select the entry again whenever you need it for another record. However, Access runs the query to the combo box only when the form is opened. If you add a new entry to the field, it will not appear in the list until you reopen the form. Fortunately, there's a quick way to update your combo box without having to open and close the form.For example, say you are entering data for a number of employees whose zip code is 07056. You enter the code for one employee. Then, when you enter the next one, you find that zip code is not on the list (Figure A).
Follow these steps:
- After entering the new zip code for the first time, move to the next record.
- Press Shift + F9.
You can use the Requery key to update any control based on SQL data.
Miss an Access tip?
Check out the Microsoft Access archive and catch up on other Access tips.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.