Code For Msgbox On A Report To Show The Difference Between To Fields., Access 2010

[nmart1230]

Hey All, I have a manifest report and on the report I have a field that gives the total count of records and another field that gives total value of checkboxes on report. I have code on the report load event that has a msgbox that states the carton is complete but I want another msgbox to state how many records are not manifested in the event that the two fields don't equal each other. Here is what I have so far for the code. Thanks!

Private Sub Report_Load()
If Me.AccessTotalsMANIFESTED = Me.AccessTotalsCLAIM_NUMBER Then
MsgBox "Every folder in carton has been manifested."
Else
MsgBox
End If
End Sub

[ranman256]

Msgbox is useless for reports.

You can put a message IN the report, txtMsg.visible = AccessTotalsMANIFESTED = AccessTotalsCLAIM_NUMBER

[nmart1230]

Okay, so can I still have a message popup that your way showing how many records are not manifested?

[June7]

What happens when you run the code?

Why do you have the Else part?

[nmart1230]

Oh, sorry I have solved the problem with this code.

Private Sub Report_Load()
If Me.AccessTotalsMANIFESTED = Me.AccessTotalsCLAIM_NUMBER Then
MsgBox "All records in carton have been manifested and shipped out on or around " & Me.DATE_BOX_WAS_SHIPPED & "."
Else
MsgBox "There are " & Me.AccessTotalsCLAIM_NUMBER - Me.AccessTotalsMANIFESTED & " records remaining to be manifested."
End If
End Sub