Displaying a query in a form and the criteria | Access forum

Resolved · High Priority · Version 2007

Thu 16 Dec 2010, 16:31 Delegate 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

Fri 24 Dec 2010, 13:10 Trainer 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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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