Edit Combo Box Values and Save Changes

[infinitx]

Hi,

I have a combo box on a form that lists Item Classifications:

Math
Science
Writing

I want to be able to select, say math, and be able to edit it and then save the changes.

Here's the row source of the combo box:

SELECT DISTINCT [tblICL 1].[ICL 1], [tblICL 1].ItemID2 FROM [tblICL 1] WHERE [ICL 1] Is Not Null And [ICL 1]<>"None";

Here's its control source:

ItemID2

Here's its other information:

Column Count: 1
Column Widths:
Bound Column: 2
List Rows: 8
Limit to List: Yes

How can I edit values in this combo box and then save the changes?

Thank you

 

[llkhoutx]

Popup a continuous form with that record source. Edit. close the popup and requery the combobox to see you changes in the list.