problem using ADO and combo box

[nqueen]

Hi,
we built a product form that is linked to access(2000)using ADO. WE created a combo box that shows the list of products. (this part works)
Every time we choose a product on the combo box, the description of that particular product should appear on a text box. (this part doesn t work). We don't seem to be able to do that. Anyone could help us please?

thks

 

[HarleyQuinn]

Just so we can see what's going wrong, can you show us what code you have so far?

Cheers

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[zemp]

The best method might depend on how you are filling your combo box. As HarleyQuinn mentioned, more information would help us help you.

If it is an unbound combo box filled from an ADO recordset then you could include the part and desc and anything else that you might need into the recordset and then disconnect it. Then when the combo box is clicked you can find the corresponding record in the recordset. Then set the resordsets position and you will have access to the desc.

zemp

 

[nqueen]

we solved the problem at the end but thanks guys

 

[zemp]

That's great. But share your solution, it will be helpful to someone else in the future and add to the value of these fora.

zemp