how to automatically update sql results in ActiveX Combobox?

[yingchai]

You can open new Query after closing existing and save the string into another variable like below

[vba]

With rs_my

.Open QQry, conn_str, adOpenStatic, adLockReadOnly

S_List = .GetString

.Close

QQry = "Second combobox query"

.Open QQry, conn_str, adOpenStatic, adLockReadOnly

S_List_2 = .GetString

.Close

End With
[/vba]

Thanks Mohan.

I will put that in. One more question, how can I pass the member selected in the combo box to the main sql query inside Module1 module?

This is something like "Select * from <table> where period = 'combobox.selected.value'?