Trying to use bookmark to set value of a text control after record selected in datacombo

I am using VB6 in Windows 2000.

I have two controls on a form. One is the order datacombo and the
other is a text control to show the price for the order selected in
the datacombo.

The datacombo is hooked up to an adodc data control.

When the user selects the order number from the data control, I would
like to fill the text control with the order price.

My source for the adodc control is "select orderNum, price from
orders".

It would seem like I should be able to use the Change event of the
datacombo to get the recordset's current record's value of the second
field (recordset.fields(1)) and show it in the text control.

However, this is not working. Do I need to use a bookmark for this?
Is there an easier way? It seems like it should be easy to do.

Can't two controls be hooked up to the same data control and report
different fields, synchronized by a bookmark?

I have tried to figure this out from Help and Google but can't find
exactly how to do it.

Thanks.
.

Relevant Pages

  • Re: Quick Search!!!
    ... > I don't believe the datacombo responds to the same messages as the normal ... Others have tried contacting the manufacturer of the control (it's ... Private Function ComboBoxIndex(ByVal lHwnd As Long, ByVal sSearchText As ...
    (microsoft.public.vb.winapi)
  • Re: Quick Search!!!
    ... I don't believe the datacombo responds to the same messages as the normal ... Others have tried contacting the manufacturer of the control (it's ... Private Function ComboBoxIndex(ByVal lHwnd As Long, ... : Private Sub Command1_Click ...
    (microsoft.public.vb.winapi)
  • Re: Suche eine Art Listview mit DB anbindung
    ... >> Gibt es da ein Control was in der Art des Listviews aussieht? ... > Analog zu ListBox und ComboBox gibt es DataList und DataCombo. ... Prev by Date: ... Next by Date: ...
    (microsoft.public.de.vb.datenbank)
  • Listview nicht Listbox ;)
    ... >> Gibt es da ein Control was in der Art des Listviews aussieht? ... > Analog zu ListBox und ComboBox gibt es DataList und DataCombo. ... Prev by Date: ...
    (microsoft.public.de.vb.datenbank)
  • Re: What Is The Goal?
    ... A single payer plan which is tax based would reduce the cost for most. ... What I believe is that whenever "someone" else pays for the cost of ANYTHING that we need or want, we have taken the rationing decision out of the hands of the person who needs or wants that product or service, and gave that decision to the one paying the bill. ... The basic reason why government rations care, is to keep control of their cost growth. ... Under the current system, YOU never get to control the price, since you are paying for the profit of a non-essential middleman. ...
    (soc.retirement)