SelectedIndexChanged event code

[di.miller]

Hi,

I am using VB 2008 Express to connect to an Access 2007 database.

I have a combo box named cboYEARMONTH that is populated by the database. I have this part working great.

When the user selects a YEARMONTH with the combo box I want the SelectedIndexChanged event to initiate a query in my database called ExactReprints_Query and limit the results to the YEARMONTH selected in the combo box. The results will then be output to a text box called TxtExactReprints.

Can anyone please help me figure out how to code this part?

Thanks in advance,
Diana

[Unhnd_Exception]

sub cmbYearMonth_SelectedIndexChanged(byval sender as object, byval e as eventargs) handles cmbyearmonth.selectedindexchanged

dim conn as new sqlconnection("?")
dim com as new sqlcommand
dim reader as sqldatareader

com.connection = conn
com.comandtype = storedprocedure
com.commandtext = "ExactReprints_Query"

com.parameters.addwithvalue("@YearMonth", cmbYearMonth.selecteditem) 'or what ever else your parameter is

txtExactReprints.clear

try
con.open

reader = com.executereader
do while reader.read
txtExactReprints.text &= reader.item("?") & vbtab
end while

catch

finally
conn.dispose
com.dispose
if reader isnot nothing then reader.dispose
end try

end sub

[Netcode]

write some of your codes out so we can figure out where the problem is