Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Displaying a query in a form and the criteria

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Displaying a query in a form and the criteria

Resolved · High Priority · Version 2007

Reply Thu 16 Dec 2010, 16:31Delegate Jamie said...

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

For upcoming training course dates see: Pricing & availability

Reply Fri 24 Dec 2010, 13:10Trainer Jacob said...

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.

Access articles

· Microsoft Access, an Efficient Database Tool
· Getting To Grips With Templates In Access 2007
· User-Proofing Your Access Database: Part 2
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Express Yourself With Microsoft Access

Please browse our web site to find out more about
access course and other Microsoft training courses.

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