Okay heres my problem!!! I have a form ‘selection’ on which I have a combo box, from which the user selects a category. This choice of category generates all the relevant products within this category to a list box.
I have an order form which includes a orders subform, this subform holds all the information of the products ordered for each particular record.
There are many products …too many for my previous drop down list..so I have a button that opens this ‘selection’ form. The idea is that the user can double click on the Products they choose from the list box……this is where I’m stuck. VB is my weakness!!! I’m not at all sure on the code for copying from a list box to a table…on 'double click' and this information going to the subform in the right record.as there is no common ID. I’ve used quite a few different codes for copying fields ..but these are all within the same form..or from text box to text box……
Any help or any ideas will be greatly appreciated…..Thanks a lot in advance to anyone who takes pity!!!!
S
I have an order form which includes a orders subform, this subform holds all the information of the products ordered for each particular record.
There are many products …too many for my previous drop down list..so I have a button that opens this ‘selection’ form. The idea is that the user can double click on the Products they choose from the list box……this is where I’m stuck. VB is my weakness!!! I’m not at all sure on the code for copying from a list box to a table…on 'double click' and this information going to the subform in the right record.as there is no common ID. I’ve used quite a few different codes for copying fields ..but these are all within the same form..or from text box to text box……
Any help or any ideas will be greatly appreciated…..Thanks a lot in advance to anyone who takes pity!!!!
S