VBA from form to report

[jk12]

Hi all. Here's my problem. In my form I have an unbound text box call AO which will show a figure based on what tick boxes are selected. The code runs on the On Current event of the form. The code used is

If [1stHalfApp].Value = True And [1stHalfPaid].Value = False Then
AO.Value = [Payment] + [RAV]
ElseIf [1stHalfApp].Value = True And [1stHalfPaid].Value = True Then
AO.Value = [Payment]
ElseIf [1stHalfApp].Value = True And [1stHalfPaid].Value = True And [2ndHalfApp].Value = True Then
AO.Value = [RAV]
End If

This works fine. However, I have since been asked to show this form as a report which means that the VBA now doesn't work in my report. Could someone please show me the errors of my ways and point out to me how this code would be adapted to work in a report please.

Thanks