I have a database for an apartment complex that generates all of the legal doucments, etc. when people move in. One of the reports pulls fields from a main form and several subforms. One of the reports pulls info from a subform that conatins rent amount, pro-rated rent amounts and has a check box that you can check if the total amount due has been paid prior to move in.
Now onto my question. On the move in report it pulls info from main form and subform that includes the info for this report. The report then totals all of them amount in a text box with a function to calculate the total due on move in. Is there a way that when the report runs if the check box is checked on the subform (that amount has been paid), I can make the textbox (with the function) show $0.00.
I am wondering if this can be accomplished by placing code in the sub_report that holds this info.
Any help greatly appreciated.
Now onto my question. On the move in report it pulls info from main form and subform that includes the info for this report. The report then totals all of them amount in a text box with a function to calculate the total due on move in. Is there a way that when the report runs if the check box is checked on the subform (that amount has been paid), I can make the textbox (with the function) show $0.00.
I am wondering if this can be accomplished by placing code in the sub_report that holds this info.
Any help greatly appreciated.
