Ms access rowsource not updating online dating site with most members
If you edit the list (adding, deleting, or modifying items), Access stores the changes in the properties of the field in the table.
Does this solve the problems associated with keeping the list in the form? If the database is split (so the table is attached), the changed Value List is updated in the linked table in the front end only.
When filling out an order, you can right-click the combo to add a new customer.
To avoid these limitations, you could choose another event to pop up the form to edit the list. Requery End If Exit_Handler: Exit Sub Err_Handler: Set the combo's Limit To List property to No, and it lets you enter values values that are not in the list.
This example shows how to add a new category by typing one that does not already exist in the combo: If the combo's source table has several fields, you need a form.Set the combo's Inherit Value List property to Yes.Now Access ignores the Row Source list in the form, and uses the list from the table instead.Access 2007 gave combos a new property to make this very easy.Just set this property to the name of the form that should be used to manage the items in the combo's list.
Perhaps the combo's Dbl Click event, a custom shortcut menu, or the click of a command button beside the combo. There are several issues to solve here, since the edit form may already be open. This approach is suitable for free-form text fields where the value might be similar to other records, but could also be quite different.