Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2003
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ACESS2000 calling ACCESS2000 (9.0.4402 SR-1)

    I have a strange problem. I have an ACCESS 2000 form (abc) calling an ACCESS 2000 form (xyz) that works fine. But if form-xyz launches the following code something odd happens when exiting the code.

    Private Sub Rel_Button_Click()

    On Error GoTo Error_Relationships

    DoCmd.RunCommand acCmdRelationships

    Exit_Relationships:
    Exit Sub

    Error_Relationships:

    MsgBox Err & ": " & Err.Description
    Resume Exit_Relationships

    End Sub


    Instead of returning to "ACCESS 2000 form (xyz)" it returns to "ACCESS 2000 form (abc)".
    It seems that the pointer to xyz is overlaid with abc. If my guess is correct how do I fix it ???

    ps.

    When I run "ACCESS 2000 form (xyz)" by its self it works fine, obviously.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ACESS2000 calling ACCESS2000 (9.0.4402 SR-1)

    I can't reproduce this in Access 2002.

    Just a wild guess: have you set the Popup and/or Modal property of one of the forms to Yes, or do you open one or both of the forms with DoCmd.OpenForm ..., acDialog ?

Posting Permissions

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