Richard... I created a form so I could track all the Sales Commissions that had been paid and the ones that still needed to be paid. I used a Sum Control Source in the Form Footer as you instructed in Video 4 to get the column totals (Total Contracts Amount, Total Expected Gross Profit, Total Actual Gross Profit and Total Commissions Paid). Everything seemed to be working fine last week. Now this week, I open up the form and these fields are not working anymore. All the fields within each of the records are fine, but I just can't get anything in these footer totals. And it's not even giving an error or anything. They're just blank. I checked to make sure they were brought to the front, in case the background was accidentally brought in front of them, but that didn't do it. I checked to make sure the Visible property was set to Yes. What other things could I check to make sure these show up again?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 3.