Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Location
    New Jersey
    Posts
    1

    Unanswered: Combobox OnNotInList Automation Error

    I'm using Access 2k and tried to use the OnNotInList event to add an entry to a combo list. The event isnt even handled, instead I get an Automation Error. Wether I manually type in the function or choose [Event Procedure] and click the [...] button.

    Any clue?

    I've gotta dig out my CD's and install the Service Packs and see if that may be the problem, but those are huge downloads and I figure i might get an answer here before they finish

    thanks for any leads

    -dan

  2. #2
    Join Date
    Apr 2002
    Posts
    1
    Dim ctl As Control
    ' Set control
    Set ctl = Me!<comboboxname>

    <comboboxname> = NewData
    ' Add new name
    If MsgBox("Your text ea. Do you wish to add " & <comboboxname> & " to the list?", vbYesNo) = vbYes Then

    Response = acDataErrContinue
    <comboboxname> = NewData
    DoCmd.OpenForm "frmStam", , , , acFormAdd


    Else
    ' Undo
    Response = acDataErrContinue
    ctl.Undo
    End If

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •