I have a table which I made a form from. The fields in the table include - OrderID, Product, ProductPrice, DeptID, and Quantity.Product and DeptID both have lookup fields with the different dept. and products in a combo box. Is there a way that I can get my price to automatically appear in its cell when I click on the Product from its combo box. I know it can be done but I'm not sure quite how to do it. Thanks

You can make the Product combobox have TWO columns: the product name and its price. Then on the combobox's AfterUpdate event you can have something like

Me.txtPrice = Me.cboProduct.Column(1)

That will put the price in the textbox based on the price in the combobox's second column.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thank you for the information. I got the 2 columns in the combo box but I didn't get selected products price which is based on the combobox's second column to go into the text box.I entered what you suggested, when that didn't work I replaced Me.txtPrice with Me.txtProductPrice. I put this code into the combobox's AfterUpdate event. I tryed several other ways with no success. I know it's a simple thing I'm doing wrong. Any other suggestions. Thanks