Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Edit Combo Box Values and Save Changes

Status
Not open for further replies.

alexbel

Technical User
Jun 27, 2004
77
US
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:

Code:
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top