HI i need help while i am using multiple combos.I am fetchig values from database and populating in combo1 and in the other combo2 i want to fetch the data wich was havig relation betwee them iam posting my code here once go though it...i am getting an eror like Novalue give for one or more Required parameters
VB Code:
  1. sqlstr = "select distinct ProductId from die1 "

  2.    rs.Open sqlstr, con, adOpenDynamic, adLockPessimistic

  3.   ' Combo2.Clear

  4.     Do While Not rs.EOF

  5.      Combo2.AddItem rs.Fields("ProductId").Value

  6.      rs.MoveNext

  7.      Loop

  8.     

  9.    ' Populating combo2 with proper scheduleId's belongs to Product

  10.   rs.Close

  11.   Set rs = Nothing

  12.     

  13.   sqlstr = "select distinct ScheduleId  from die1  where productid= " & Combo2.Text & ""

  14.   

  15.   Set rs = New ADODB.Recordset

  16.   rs.Open sqlstr, con, adOpenDynamic, adLockPessimistic