help with access relationships

[eric is pulling hair out]

I am ready to scream. I have been trying to get this right for months. I have
a customer invoiceing database that has worked very well for me. But takes
longer to fill in.

Currently I have to key in the product ID number, the quantity, Type in the
product description, then the item price.

I wanto to set up so I key in the product ID number, and it fills in the
product description and its price automatically.

I just can not get how to do this. Any that can help I will be so grateful.

 

[Allen Browne]

Open the Northwind sample database that installs with Access.

Open the order details subform.

Look at the AfterUpdate event of the ProductID combo box.
That shows how to look up the current price when a product is selected.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"eric is pulling hair out" <eric is pulling hair
(e-mail address removed)> wrote in message
news:[email protected]...