run VBA if/else statement in report?

[viveleroi]

I have a report and I want to do an if/else statement for each record in the report. It essentially says if the value of one field (from a query) is x, then assign a value of y to another field in the report.

But I cannot figure out how to do this. The code works in AfterUpdate on forms, but how do I tell the report to run the code?

 

[ghudson]

Use the OnOpen event of the report.

 

[Rich]

Use the Detail On Format event

 

[viveleroi]

I can't get this to work with OnOpen or OnFormat:

Private Sub Detail_OnFormat()

    Me.initPTO = 40

End Sub

I have verified that initPTO is a true field in the report. This is just a test, I really have an if/else statement but thats no good if I can't even assign a value to a field.

 

[viveleroi]

I figured it out - the sub line should have been:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Not

Prive Sub Detail_OnFormat()