98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Displaying a query in a form and the criteria | Access forum
Displaying a query in a form and the criteria | Access forum
Resolved · High Priority · Version 2007
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
Fri 31 Dec 2010: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Prefixed AutonumberingWhen using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter. |