Pretty basic. I have a combo box that the user selects from. Once they select an item I want the price that is associated with that item to auto-populate into the unit price field on the add screen. In the table that the combo is attached to I have an ID field, a item field and a price field. The combo is of course attached to the item field. How Do I make the unit price field on the add form fill with the correct value?
Thanks,
Corinne