Extracting data from one box to input another?!

[mattpearcey]

I have a form at present that aims to show what products the record on view has heard of / or uses. Currently, i have just put a large memo box in there so the user just types in the data for each record.

What i want to do is split this up into 2 boxes. One that is a list of all the products we have (like in tha table or list), and the other is blank. So, the user then picks from the first box, the data that they want to enter int he second box. Similar to when you set up query's, so you ccan double click or drag the products over to the second box.

This will a) make it look better, b) make it easier to user, and c) make it easier to report on and keep the same.

Can someone poitn me in the direction of how to do this? Is this a list box thing, or something different?

Thank you for your help already.

Matt Pearcey

 

[DougP]

I would create a subform that has all of the parts showing like this.

http://www.barcodeone.com/winsoft/images/Safety_Stock_Level.gif

then when the user picks on it adds it to another list or something.
rummaging around in Text boxes is tough and Memo field are not a good solution to retrieve data from.

This uses a LIST box at the top and Subform at the bottom.
When the user picks an item it highlights and stays that way until they are done. The highlighted item is added to a temporary table that the bottom Subform is connected too.
So if the pick an item by mistake they can easily go down to the subform and delete it.

Then when they need report or query it is very easy to create form a table instead of a text box.


DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive