Access 2007: automatically filling fields

August 21, 2009 at 05:16:04
Specs: Windows Vista
I'm using microsoft Access 2007 and I'm trying to figure out something.
I have a table called 'orders' which contains information about the customer and product etc. I also have another table called 'products' containing information about the product.

One of the fields that needs to be filled on the order form is 'Product code' and another one called 'Cost of item'. When the user fills in the product code how can I get access to automatically fill in the field 'Cost of item'?

I hope that makes sense!
To clarify, bascially how to i get one field to be filled in automatically based on another field in a DIFFERENT table?


See More: Access 2007: automatically filling fields

Report •

August 21, 2009 at 21:23:51
From memory ( I havn't done any Access work for a while)
you would use the lookup function and set the fields that you need to fill in. That means you would need to have the matching product code in the table with the price.
If you install the Access help and programming extras from the cd (requires custom install) but can be added after instalation, you will have a variety of business database samples to help you.
If you need more help repost in the Office Forum where you may get a quicker response.

Report •
Related Solutions

Ask Question