Inventory management database



I am new to access and have downloaded the inventory management database.

I need to link the unit price field on the purchase order to the unit price
field on the products form, how is this done?

I have my products in the products form with the prices saved but when I
create a purchase order I have to manually input the unit price. Is there any
way to do this automatically?

Al Campagna

Very basically...
Since you'll be entering many products, use a combo box to allow the user to select any
product from that combo. Use your Product/Price table as the RowSource for the combo.
The combo ControlSource will be your Invoice table Product.
2 Columns... (Access numbers combo columns 0, 1, 2, 3, etc...)
Col0 Col1
Product Price

On the AfterUpate event, the Product will be captured to the Product field of your
Invoice table. Then using a macro or module code, on the AfterUpdate event of the combo,
programatically set the value for your Invoice table Price field. (Assume the combo is
named cboProduct)
Private Sub cboProduct_AfterUpdate()
InvoicePrice = cboProduct.Column(1)
End Sub

This is just the basic concept on using combos to select a value, and in this case...
populate other field/s. Study up in Help, or any Access documentation.

Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP

"Find a job that you love, and you'll never work a day in your life."

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database design 0
inventory control 3
Help with Data Control Source 1
Combining 3 queries 2
Multi Table query 2
Doing Math in Forms 3
Calculation in Access 1
averaging the cost of a subform to a main form 2