Code question (1 Viewer)

[Peter Paul]

In a database, when the user logs in I have a query which looks to see what reports the user needs to write, (based on their logon,) and then shows a pop-up form with those reports listed. Until today, I had it working so that if there were no outstanding reports, that the form would cancel. I upsized the backend to SQL and have been putting out small fires all day on the database, this is one of them.

IF the user has outstanding reports, it works fine and dispalays the data. IF they user does not have outstanding reports, it shows a blank form which the user has to close. On the original database, (before upsize, yes I kept a backup copy,) it works great.

In the On Open property I have this code:

Private Sub Form_Open(Cancel As Integer)

If IsNull([Forms]![Overdue]![Numbers subform1].[Form]![Case_Incident_Number]) Then
Cancel = True

End If

Any thoughts as to why this would not work?

Thanks for any help,
Peter Paul

 

[PrincessBretti]

Hi Peter,

What exactly is going wrong? error message, etc.

Bretti