Selecting a product which automatically puts item in seperate box

[markswan20]

Hi all

I have a problem at the moment that i need a little help with.

I have created a form with a little help from some folks on here. I have a listbox with 15 different products in i am looking to be able to select the relevant product press a key or button that will transfer the information to a different box. Could someone help plese preferably in laymans terms

Kind Regards
Mark

 

[PHV]

In the AfterUpdate event procedure of the listbox set the textbox value to the appropriate column value.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[markswan20]

Will this work for multiple values?

Example. If i need 2 products, select the first press your key\button, then select the second and press the key\button will it overide the first product?

Cheers

 

[PHV]

If you want to play with a MultiSelect listbox you may consider a button to process all the ItemsSelected collection in one loop.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[markswan20]

I'm still a beginner with Access how would i go about doing what you suggested?

Cheers

 

[markswan20]

Would it be possible for someone to elaborate on this for me please.

Cheers

 

[PHV]

What have you tried/searched so far ?
Please, feel free to read carefully the 2nd FAQ in my sig.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886