Arrg!! what is wrong with this code?

[RBE]

I am not getting any error messages or anything it just comes back with a blank value. I have created invisable fields to see if the report was reading the form and other report fields and they are getting to the report fine the code just does not bring back any values. This code is located in the detal section of the report along with all the other rptDGLRPT fields. Helllllp!!!

If (Reports![rptDGLRPT].[PRODUCT CODE] = Forms![frmDGLRPT].[product1]) And (Reports![rptDGLRPT].[running sum] < Forms![frmDGLRPT].[GALLONS1]) Then
Reports![rptDGLRPT].[GALREC]
ElseIf Reports![rptDGLRPT].[running sum] > Forms![frmDGLRPT].[GALLONS1] Then
Reports![rptDGLRPT].[GALLONS_RECEIVED] = Reports![rptDGLRPT].[running sum] - Forms![frmDGLRPT].[GALLONS1]
End If

 

[gcole]

Put a stop before the code and check each of your values. This should debug your code and give you the answer.