How do I display the last record?

[daddylongtoe]

Hi

I am trying to setup a basic purchase order generating system for our nurses to use when ordering supplies. The problem I am having is that I have a table setup to take details of products we order including descrption and price, but when I raise a new order it doesn't disply the price as recorded in the Products table, even if I select the appropriate source.

As I fill out a new purchase order it allows me to select the product from a drop down list, but then it requires the price to be entered again. The source is calling for UnitPrice, which is what the field is called in the Products table. Also, when I enter a cost in manually it doesn't update the cost in the Products table either, only on the PurchaseOrder table.

The problem lies between the tables/forms for Products & PurchaseOrders. I want the purchase order to contain the price as recorded in the Products table when the item is selected. If there is an updated the price the nurse should be able to type this in as she fills out the order and it will update the Products table.

I hope this makes some sort of sence, but I welcome any questions as I'm sure you'll require more details. I will greatly appreciate any help.

Thanks



Steve

[RuralGuy]

You need to use the AfterUpdate event of the ComboBox to fill in the price from the RowSource of the ComboBox. Me.PriceControl = Me.ComboBox.Column(2)
...replacing the RED values with the actual names of your controls. The Column(n) value is zero based so 2 would be the 3rd column.