After the user has closed the Categor圜odes form, the category combo box would requery its values. So when the user double-clicks on the category combo box, the form called 'Categor圜odes' would open. For example, Private Sub Category_DblClick(Cancel As Integer)ĭoCmd.OpenForm 'Categor圜odes', acNormal,, ,, acDialog Ideally you will want to validate data at the lowest level possible, so if you can enforce the rules at the table level (using Primary Keys), thats great. Click on the property called 'After Update'. Database Solutions for Microsoft Access - Preventing Duplicates from being entered: There will always be situations where you need to ensure that you do not have duplicates entered into your database. To do this, select the properties for the ContactTitle text box. Next, you need to place similar code on the text boxs After Update event. In our example, you would place this code in the double-click event after the 'DoCmd.OpenForm' code. You can close down the Microsoft Visual Basic window.

Created by Jason Bailey on 22 November 2001 and last updated by.

The Requery method forces the combo box to refresh the values that it lists. This is question number 898, which appears in the following categories: Software > Databases. In this example, you have a combo box called Category. To do this, you will need to call the 'Requery' method for the combo box. The only problem with this is that you need to refresh the combo box values after the user has left the code table screen. For example, if a user clicks on a combo box and the value that they are looking for is not present, you can set up the combo box to launch the corresponding code table on the combo box double-click event. How do I refresh the values in a combo box?Īnswer: Sometimes it is necessary for the user to update code tables while they are using the system.

After I add a new value to the code table it doesn't appear in the combo box list. Question: In Microsoft Access 2013, I've created a combo box that is populated by a code table. See solution in other versions of Access:

Microsoft access after update