displaying query form and

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum 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

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



View all Access hints and tips


Server loaded in 0.08 secs.