Combo box/ Text box Refreshing

[mapat]

Hello,

I have a combo box displaying StockDescription on a form from a Stock table (StockDescription, StockPrice). Whenever I select a certain desc. from the combo box, I want it to be displayed the price on a searate text box. Whenever I select an item for the 2nd time, it doesn't update the text box with that 2nd item chosen from the combo box. It doesn't refresh the item. How do I solve this??

Thank you very much.

 

[KernelK]

How do you have it set up? Do you have code associated with this? If so post that, at the very least a more detailed description of how you are attempting to accomplish the task already and maybe somebody can help you better.

 

[dbrown78]

Maybe this will help

Hi,

If this doesn't help you, try doing what the Kernel suggested and post a bit more info, but I think I know what you are trying to do.

In the Format tab of your combo box properties set the ColumnCount to 2 and the ColumnWidths to 2.54cm;0cm. This will display the Stock Description text and hide the StockPrice. In the Event tab of your combo box properties click the ellipsis [...] button next to After Update and enter the code:

Me.[Name of your Stock Price Field].Value = Me.[Name of your Stock Description Field].Column(1)

I've attached a quick sample to let you see what I am talking about. Hopefully I have understood your query correctly.

 

[mapat]

I followed what your steps and it worked just fine.

Thank you very much.

Hi,

If this doesn't help you, try doing what the Kernel suggested and post a bit more info, but I think I know what you are trying to do.

In the Format tab of your combo box properties set the ColumnCount to 2 and the ColumnWidths to 2.54cm;0cm. This will display the Stock Description text and hide the StockPrice. In the Event tab of your combo box properties click the ellipsis [...] button next to After Update and enter the code:

Me.[Name of your Stock Price Field].Value = Me.[Name of your Stock Description Field].Column(1)

I've attached a quick sample to let you see what I am talking about. Hopefully I have understood your query correctly.