Web PO Form - how to get the subform (lines) right

[Larry Kates]

Here is what i am trying to do: (pretty straighforward normally). User fills in header info, then selects a line item on the subform, fills in qty and (this is the part that is giving me fits) selects an inventory item from a combo box based on a query bound to the inventory table. The control source of the combo box is the POLines ItemID. The combo box has columns which display the item description, unit, and price as well. When the user selects the item, i need to set the values of the Units and UnitPrice text boxes which are bound to the POLines Unit and UnitPrice fields respectively.

If i could use VB, i would mearly set the value properties of the text boxes to a column of the combo box, and that would do the trick. In web forms, the column of the combo box is not available. How can i get the information i need from the inventory table into the POLines table?

 

[Larry Kates]

never mind - i got it to work. As usual, use a query as the basis of any form.