I downloaded the MS Access Template "Time and Billing" to set up for a small business and the Invoice isn't pulling in the correct data based on the filter that is applied. Since I didn't create the db myself I am having a heck of a time trying to resolve the problem. Everything else I have set up for the db is working fine, just not the invoicing part. I set up a couple dummy accounts in a test database so that I could share it here (see attachment).
I created a project for two customers and when I click on the "Project Details" form the information is displayed correctly for all subforms. However, when I click on "Print Invoice" the invoice displays the first customer's information no matter which customer I am looking at. If I click on the "Invoice" report directly, I never know which invoice is going to come up. When I look at the code for the invoice the Filter is set to [ProjectID]=1. I don't know enough about the code for the filter to decipher how to get it to filter to the record displayed and not the first record in the list. I've tried different variations and can't get anything to work. Either I'm not looking at this correctly or there is a bug in this particular template.
Any assistance would be helpful.
Thank you.