report says "No current Record" when in print preview

[RLehrbass]

Report says 'No Current Record' when viewing with print preview, even though it works fine in report view?
What did I do?

[June7]

Never encountered this before. Would have to review report design. If you want to provide db for analysis, follow instructions at bottom of my post.

[ranman256]

ive seen this when there are zero records to print.

[June7]

ranman, if records show in ReportView then should also show in PrintPreview.

[RLehrbass]

i found a reference in a microsoft saying something about the report has a group on or group footer set, but I don't understand exactly what they are saying.
https://support.microsoft.com/en-us/kb/888635

[June7]

If you have not set any Sorting & Grouping parameters in the report design, then that cannot be cause.

Again, if you want to provide db ...

[RLehrbass]

Moderator,
I have tried so many things on the report last night. I appreciate you looking at it for me. Membership-database-constructionSecurityProtection8-26-15.zip
rptInvoiceBalDue it will load with all records in report view but will not load in print view?

Look around the db while you are in there so you can understand our previous interactions...

[June7]

Opening report from the menu does not trigger the popup error message but there is no data, just #Error in the textboxes.

I commented out all the code in the report Load event and the report displays properly in PrintPreview. Need to put this code in a different event. If you want the edits to tblTranasactions to be reflected in this report, then do the edits before calling the report. Switching between report views causes the Load event to run again so you get more records saved. Probably need conditional code that searches the tables and only creates records if not already there.

[RLehrbass]

Moderator,
OK. i resolved the error. The error was being introduced by the requery at the end of the VBA code. I resolved this by changing the event procedure from 'on load' to 'on open', now that part works great.

Question: Everything is working correctly, but my report generates an invoice even when there is a zero balance. How can I tell the report that I only want to report when the [balance] is greater than zero.

[June7]

Okay, what you call an Invoice, I would call a Statement or a Notice. An invoice to me shows products purchased and payments (like cash register receipt from grocery store).

Try criteria under the Balance field in query: <>0

Or apply criteria when opening report - VBA would be like:

DoCmd.OpenReport "reportname", acViewPreview, , "Balance <> 0"

[RLehrbass]

The <>0 in criteria did the trick.
Once again. Thank you for the assistance.
You are appreciated!