ListBox and new Table 1

[SJW]

I am a Electrical Contractor tring to write a program for P.O. Numbers.<br>I made the P.O.Number part of it work fine<br><br>Now im on a part with listboxes <br><br>The list box is named ItemList which as ItemID, Description, Price and Per. I would like to double click one item in the listbox and put that information in a new table named POInfo.<br><br>Can someone help me with this.<br><br>Thank you very much,<br>Steve

 

[DougP]

Is this a list box or a subform?<br>in the On_click Event of either<br><br>would be for a List box<br>Me![Textbox on your form] = me!List1.Column(0)<br><br>Subform<br>Me![Textbox on your form] = me![SubformName].form![fieldname]<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[SJW]

Thanks DougP that worked<br><br>Now when I double click the listbox the information goes to the subform just fine, but it will not let me add a new record.<br>Everytime I double click, it changes the information that was clicked the first time.<br><br>Can you help on this one.<br>Thanks,<br>Steve