Susan Harkins
ssharkins at gmail.com
Wed Oct 31 15:42:35 CDT 2007
The following is a simple event procedure that updates a value list combo with user input. It works fine. The problem is, the form won't save the new item. The next time you open the form, the newly added item's gone. It's kind of like, the form doesn't think there's anything to change, because I don't get the Save prompt. Susan H. Private Sub cboMetals_NotInList(NewData As String, _ Response As Integer) 'Update value list with user input. On Error GoTo ErrHandler Dim bytUpdate As Byte bytUpdate = MsgBox("Do you want to add " & _ cboMetals.Value & " to the list?", _ vbYesNo, "Non-list item!") 'Add user input If bytUpdate = vbYes Then Response = acDataErrAdded cboMetals.AddItem NewData 'Update RowSource property for 'XP and older. 'cboMetals.RowSource = _ ' cboMetals.RowSource _ ' & ";" & NewData 'Save updated list. DoCmd.Save acForm, "ValueList" 'Don't add user input Else Response = acDataErrContinue cboMetals.Undo End If Exit Sub ErrHandler: MsgBox Err.Number & ": " & Err.Description, _ vbOKOnly, "Error" End Sub