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

 

[koala15]

Just a thought (because I do not really know what you are trying to achieve), should the code not be:

If (Reports![rptDGLRPT].[PRODUCT CODE] = Forms![frmDGLRPT].[product1]) Then
If (Reports![rptDGLRPT].[running sum] < Forms![frmDGLRPT].[GALLONS1]) Then
Reports![rptDGLRPT].[GALREC]
Else Reports![rptDGLRPT].[running sum] > Forms![frmDGLRPT].[GALLONS1] Then
Reports![rptDGLRPT].[GALLONS_RECEIVED] = Reports![rptDGLRPT].[running sum] - Forms![frmDGLRPT].[GALLONS1]
End If
End If &quot;Life is full of learning, and then there is wisdom&quot;