Lavenderchan
Technical User
Hi I've got a preview report that I've added to a form but I don't want it open and where else so I added this code
Private Sub Report_Open(Cancel As Integer)
If Not IsLoaded("Tracking Log") Then
MsgBox "Open this report using the Preview button on the Tracking Log form."
Cancel = True
End Sub
but its saying sub or function isn't found. I was wondering why the IsLoaded might not work. I did some reading to my understanding they added something to 2003 access with the IsLoaded but I'm not sure why its effecting my code now. Any insight would be helpful.
Keri
Private Sub Report_Open(Cancel As Integer)
If Not IsLoaded("Tracking Log") Then
MsgBox "Open this report using the Preview button on the Tracking Log form."
Cancel = True
End Sub
but its saying sub or function isn't found. I was wondering why the IsLoaded might not work. I did some reading to my understanding they added something to 2003 access with the IsLoaded but I'm not sure why its effecting my code now. Any insight would be helpful.
Keri