Results 1 to 2 of 2

Thread: NotInList

  1. #1
    Join Date
    May 2002
    Posts
    37

    Unanswered: NotInList

    Hi All...
    Here's the scenario...
    I have a combo box, limit to list set to yes...
    Event On Not In List calls a public function that looks something like this:

    Public Function notlisted()
    Dim stDocName As String
    Dim stLinkCriteria As String
    stDocName = "frm_deliverable"
    Dim mymsg
    mymsg = MsgBox("Do you wish to add a new Deliverable?", vbYesNo, "Not in List")

    If mymsg = vbYes Then
    MsgBox "u said yes"
    'To be replaced once I have it working the right way
    Else
    If mymsg = vbNo Then
    MsgBox "u said no"
    'To be replaced once I have it working the right way
    End If
    End If
    End Function

    All this works well and good, except I still have the annoying access error pop up window "The text you entered isn't an item in the list".

    How can I trap for this error to prevent the pop up?
    Thanks!

  2. #2
    Join Date
    May 2002
    Posts
    37
    Added this line, fixed it...

    Response = acDataErrContinue
    Call notlisted

Posting Permissions

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