Populating the listbox depending on the selected item from dropdown listbox.

Results 1 to 2 of 2

Thread: Populating the listbox depending on the selected item from dropdown listbox.

  1. #1
    vijay Guest

    Default Populating the listbox depending on the selected item from dropdown listbox.

    i want to know how you can populate a list box depending ,say if you select an number ID from the Dropdown listbox related data should populate in the listbox.<BR>i would appreciate if you can suggests some good sites or send a solution on this question.<BR><BR>thank&#039s<BR>vijay

  2. #2
    Jay Reid Guest

    Default RE: Populating the listbox depending on the selected item from dropdown listbox.

    If you&#039re using Interdev:<BR><BR>Sub Listbox1_onchange()<BR>param=Listbox1.Getvalue()<B R>Recordset2.close()<BR>rstSql= "SELECT * FROM Employees WHERE FirstName = &#039"& param &"&#039")"<BR>Recordset2.setSQLText(rstSql)<BR>Rec ordset2.open()<BR>End Sub<BR><BR><BR><BR>This would be where Recordset2 was the recordset for the 2nd list box.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •