[program-l] Re: VB6: Click Event of a Combo Box
- From: "Justin Daubenmire" <justind@xxxxxxxxx>
- To: <program-l@xxxxxxxxxxxxx>
- Date: Fri, 9 Sep 2005 10:07:51 -0400
does this work in the click event?
lngRecordID = cbx.itemdata(cbx.ListIndex)
Justin
----- Original Message -----
From: "Corbett, James" <James.Corbett@xxxxxxxxxxxxxxx>
To: "Program-L (E-mail)" <Program-L@xxxxxxxxxxxxx>
Sent: Friday, September 09, 2005 9:44 AM
Subject: [program-l] VB6: Click Event of a Combo Box
Hello all:
I am using a Combo Box with its Style property set to 2. The Combo Box is
populated during the form load event with a query to a table. During the
population, I reset the index with:
Do while not rs.eof
cbx.additem rs.fields("field").value
cbx.itemdata(cbx.newindex) = rs.fields("Auto Number Field").value
loop
So, essentially what happens here is that the index values get
repopulated.
My issue is that I want to use the index value during the click event to
repopulate other controls on the form but due to the new order of values I
can't seem to return the expected value thus screwing up my secondary
query.
Is there an event that would return a more accurate value? In other words
if I press the down arrow, I want the value of the item that I land upon.
Jimmy
James M. Corbett
(613) 941-8303 | facsimile / télécopieur 613 941-8720 | TTY/ATS
1-800-665-0354
James.Corbett@xxxxxxxxxxxxxxx
IT Programmer/Analyst | GST/HST Division | Information Technology Branch
Programmeur/Analyste en technologie de l'information | Division de la
TPS/TVH | Direction générale de l'informatique
Canada Revenue Agency | 875 Heron Rd., Ottawa, ON K1A 0L5
Agence du revenu du Canada | 875 Ch. Heron, Ottawa ON K1A 0L5
Government of Canada | Gouvernement du Canada
"It's 106 miles to Chicago. We got a full tank of gas, half a pack of
cigarettes; it's dark and we're wearing sunglasses."
Elwood Blues
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
