Getting information from forms

[Guest]

Hello,

I am trying to make a form where people can buy items. Each item is in a
table called Items. Each record has a name and a price.

They select the items by a check box, and a combo box. I cannot get the form
to work out the prices as I don't konw how to get the prices from the table.
I have tried some things with the combo box but it just displays the price
not the name. I want to display the total at the bottom.

Hope you can help, Thankyou.

James.

 

[Allen Browne]

Open the Northwind sample database.
Open the form called Orders Subform.
Look at what that example does in the AfterUpdate event of the ProductID
combo.