Simple, use disconnected Recordsets and then Filter them based on the
selection in the first Combo.

-----Original Message-----
From: Verhoeven Bart [mailto:bart.verhoeven@p...]
Sent: Wednesday, March 28, 2001 2:50 AM
To: professional vb
Subject: [pro_vb] RE: ComboBox troubles


Thanks for the information, but i have a follow up question regarding
this

I gat three comboboxes. All three are filled with data from a database
(without keeping the connection open). Now when a user selects something
in the first combobox the other two's have to show one item from the
list they contain.

How do I do this ???

Verhoeven Bart

-----Original Message-----
From: avance@c... [mailto:avance@c...] 
Sent: vrijdag 23 maart 2001 10:43
To: professional vb
Subject: [pro_vb] RE: ComboBox troubles

Just to add to this...
To get your id back after a selection...

Use

	ID = cboMyBox.ItemData(cboMyBox.ListIndex)

Al.

-----Original Message-----
From: Chris Tacke [mailto:ctacke@r...]
Sent: 22 March 2001 23:05
To: professional vb
Subject: [pro_vb] RE: ComboBox troubles


rs contains
-----
ID    Name
===========
1	Bob
2	Jim
3	Bart

Do While Not rs.EOF
	cboMyBox.AddItem rs!Name & ""
	cboMyBox.ItemData(cboMyBox.NewIndex) = rs!ID
Loop

-----Original Message-----
From: Verhoeven Bart [mailto:bart.verhoeven@p...]
Sent: Thursday, March 22, 2001 5:50 PM
To: professional vb
Subject: [pro_vb] ComboBox troubles


Hi,

Can anybody give me the exact how to add in a combobox a list with names
and
also add the index number for each entry.
Idea after it is that i want a list with personnel names, but the
combobox
should return the personnelnumber ID.

Hope you guys can help me ...


Verhoeven Bart