How to populate a combo box based upon a datacombo?

[longmatch]

I am designing a form with a datacombo control and a regular combo box. What I need to do is to populate a list in the combo based on the selection of the datacombo. How to do this, any examples?

Thanks

Haijun

 

[SpeakUp]

Set db = Opendatadase("Your Database&quot
Set rs = db.OpenRecordset("Select * From TableName Where
Field1='" & Datacombo.text & "'&quot


With rs
combobox.clear
Do
combobox.AddItem !Field2
.movenext
Loop Until .EOF
End with

rs.Close
Set rs = Nothing

 

[longmatch]

Do I need to use connection object to connect database?

Haijun

 

[longmatch]

Do I need to use connection object to connect database? If I use datacombo, How can I do it?

Haijun