inventory control

For the last year I have been trying to do my ordering
and Inventory Control with Access. I have a great
database but I cannot figure out how to bring the unit
price form my product table or form automatically to the
purchase order form when I pick a product. I is working
in the "order sample", but I can't duplicate it for my
order control data base. Can you help??

Elke,

Once you get the hang of it, you will find that using a combo box with
multiple columns to fill other controls on your form is pretty easy! Here
is a link explaining step-by-step how to populate controls on a form using a
multi-column combo box:

http://support.microsoft.com/default...9482#appliesto


--

Cheryl Fischer, MVP Microsoft Access



"elke" wrote in message
...
For the last year I have been trying to do my ordering
and Inventory Control with Access. I have a great
database but I cannot figure out how to bring the unit
price form my product table or form automatically to the
purchase order form when I pick a product. I is working
in the "order sample", but I can't duplicate it for my
order control data base. Can you help??