Putting Data in Subform

[Ma3x323]

My subform is connected to a table. Above the subform is a list box that lists several stuff. Is it possible that when I do a Double Click event that I can store what I need from that ONE LINE to the subform below? My subform is in a tabular form so I am also wondering if you keep double clicking stuff from above, can you keep putting all this data to the subform.

ListBox:
-----------------------------------------------------------
Item # Price Company Description
Bag 1 3.99 Bum bleach color
Pencil 2 .50 Lead HB
Watch 3 400.00 Rolex New
Shoes 4 65.95 Nike Old
-----------------------------------------------------------


Subform (clicked items)
-----------------------------------------------------------
Company Item # Price Quantity Final
Lead Pencil 2 .50 100 50
Nike Shoes 4 65.95 1 65.95
-----------------------------------------------------------

And then of course the total TOTAL: 115.95


Does anybody know how to do this?
SOmebody better answer cuz it took me a while to make this stuff >:-<
j/k X-)

i just need help

Thanks,
Feryl

 

[gusbrunston]

Dear Feryl:

I keep looking at your post, hoping that someone who understands your problem better than I do will answer.

I'm not sure what you're trying to accomplish with your form and sub form. Is the Form based on one table, and the sub form on another? Is one an &quot;Orders&quot; table and the other an &quot;OrderDetails&quot; table. Do the tables have a &quot;one to many&quot; relationship? If not, why are you using a form with a sub form?

I think you'd get some help with further explanation.

Best of luck,
Gus Brunston
An old PICKer
padregus@home.com