Code Debugging

[Neil Greenough]

I was recently tidying up my DB and was tidying one of my reports which is
generated from a form with a script in it. The script is:-

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.txtWordCount = Forms!Translators!txtWordCount
If PrintCount <> 1 Then
Else
If intPreviousTranslatorID = Me!ID Then
Me.MoveLayout = False
Me.NextRecord = True
Me.PrintSection = False
Else
intPreviousTranslatorID = Me.ID
End If
End If

End Sub

I think I may have deleted something important from the report. When I go to
run the report, I get a "Compile error. Method or data not found" message.
The following parts are highlighted in the above script:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.ID

I think that I may have deleted the ID part from a report.

Anybody got any ideas how I can go about fixing this?

[Brian]

"Neil Greenough" <ne***********@btopenworld.com> wrote in message
news:ck**********@hercules.btinternet.com...

I was recently tidying up my DB and was tidying one of my reports which is
generated from a form with a script in it. The script is:-

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.txtWordCount = Forms!Translators!txtWordCount
If PrintCount <> 1 Then
Else
If intPreviousTranslatorID = Me!ID Then
Me.MoveLayout = False
Me.NextRecord = True
Me.PrintSection = False
Else
intPreviousTranslatorID = Me.ID
End If
End If

End Sub

I think I may have deleted something important from the report. When I go to run the report, I get a "Compile error. Method or data not found" message.
The following parts are highlighted in the above script:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.ID

I think that I may have deleted the ID part from a report.

Anybody got any ideas how I can go about fixing this?

Did you try Me!ID instead of Me.ID ?

[Neil Greenough]

Problem solved.

Thanks

"Neil Greenough" <ne***********@btopenworld.com> wrote in message
news:ck**********@hercules.btinternet.com...

I was recently tidying up my DB and was tidying one of my reports which is
generated from a form with a script in it. The script is:-

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.txtWordCount = Forms!Translators!txtWordCount
If PrintCount <> 1 Then
Else
If intPreviousTranslatorID = Me!ID Then
Me.MoveLayout = False
Me.NextRecord = True
Me.PrintSection = False
Else
intPreviousTranslatorID = Me.ID
End If
End If

End Sub

I think I may have deleted something important from the report. When I go to run the report, I get a "Compile error. Method or data not found" message.
The following parts are highlighted in the above script:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.ID

I think that I may have deleted the ID part from a report.

Anybody got any ideas how I can go about fixing this?