lost reference (error 2467)

[SimonSellick]

Hi,

A few threads have this error number but none seems to address the same issue.

The process runs as an event handler on a form. It opens a dialog form (a progress bar mostly) then when it completes, closes the dialog form and writes a completion message to a label on the calling form, which is still open.

All is well unless I change focus away from Access during the process. In that event, the attempt to write the completion message fails with the error 2467 and the message 'The expression you entered refers to an object that is closed or doesn't exist.'

The statement that fails is simple:

Private Sub Status(s As String)

    [red]lblStatus.Caption = s[/red]
    
End Sub

If I debug when it has failed, the immediate window shows that the calling form is available as 'Me' and shows its controls and properties, but it can't actually get at them - an attempt to print one repeats the error.

Any ideas, anyone?

 

[Remou]

I tried a mock-up, which consisted of FormA, with this code:

Private Sub Status(s As String)
    lblStatus.Caption = s
End Sub

Private Sub Detail_Click()
DoCmd.OpenForm "FormB", acNormal, , , , acDialog
Call Status("Done")
End Sub

And FormB which simply closed on a timer (interval 3000)

Private Sub Form_Timer()
DoCmd.Close
End Sub

Switching away from Access did not cause any problems.

 

[SimonSellick]

Thanks for the reply Remou.

I tried your code and it works OK here too, so I'll experiment with some of the extra code to see when it starts falling over, and report back.

Simon