Jamie has attended:
Access Introduction course
Access Intermediate course
Displaying a query in a form and the criteria
Hi,
I have designed a database for keeping track of invoices we receive in our finance team.
Information collected included name of supplier, date, amount, invoice number etc
On the form the supplier is selected from a drop down list of over 3000 suppliers we deal with which I have uploaded into seperate table.
When a new invoice is added, and the supplie selected from the drop down list how am I able to show at the side of the form, a summery of all the previous invoices from just that supplier that has been selected?
I assume I need to run a query, however I'm unsure of the criteria so that just that supplier selected on the form is shown.
Cheers,
Jamie
RE: Displaying a query in a form and the criteria
Hi Jamie
Thanks for your post, I have run this by a few of our Access trainers and there are 2 options we can suggest to help you reach a solution.
Option 1:
Attend our MS Access Advanced course
This will provide you with sufficient knowledge to resolve your requirement.
Option 2:
We create the solution for you, just email us your files and we let you know the development time and costs to do this.
Regards
Jacob
