Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Posts
    27

    Unanswered: Parameter query on close

    I am getting a parameter query prompt from this code when I go to close the form, I have no idea why, just upgraded to Access 2003. Thanks.

    Public Function ClosePCR()
    'Stop
    Forms![frmPCR].Refresh

    If intCheck = 1 Then
    DoCmd.CancelEvent
    intCheck = 0
    Exit Function
    Else
    DoCmd.Close acForm, "frmPCR"
    End If

    End Function

  2. #2
    Join Date
    Nov 2004
    Location
    Norway
    Posts
    441
    I think you can only cancel the events having a cancel arguement, and in those, it's better, I think to use Cancel = true. Here you're within a public function, so I don't know whether it would have any effect at all.

    The parameterthingie, could perhaps be this
    http://support.microsoft.com/?id=811860
    (either the one specified, or one found through the referenced articles)
    Roy-Vidar

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Could you be a little more specific about the prompt you're getting?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Feb 2005
    Posts
    27
    Forms!formPCR!PCR # is the prompt I am getting, thanks.

  5. #5
    Join Date
    Feb 2005
    Posts
    27
    Thanks Roy!!! Never would have guessed that one!!! Works.

Posting Permissions

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