Joined: 04 Sep 2010
Location: RIchmond, KY
|Posted: Thu Sep 09, 2010 6:09 am Post subject: Help using Listbox to return 2nd field value
|I have a question about this form.
This list box (Products in the subform) uses an SQL statement to show the Description field from the table Products. When I select an item from the shown drop-down list of this listbox, I want to pass the Price from the Products table to the next field in this subform (Next column after the listbox).
In Access I did this with a ListBox that contained 2 fields, I can't do this in OpenOffice. I don't need to see the value first, just pass it to the Price field. I saw several posts about concatenating data & using Message Boxes to view the data. I don't need to do that.
Can anyone help me with the code or process to pass Price from table Products to the ItemPrice field in the InvoiceItems table when selecting the Product from the listbox. The subform with the listbox is based on the InvoiceItems table.
Here is my database relationship structure.