Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

list box dtc question

Status
Not open for further replies.

newtoASP

Programmer
Jun 1, 2001
40
US
How do I retrieve the value of a selected item in a dropdown listbox? I would like to use this value as a parameter to refresh a recordset. Is there a find method that I could use with the rs dtc? When a user selects a name from this list box, I would like other text boxes on the page to display other fields from the same rs. I have tried both static client and server side cursors, as well as dynamic and keyset cursors on the server side.
 
look on microsoft...
Article ID: Q194018

Individuals commonly want to display a list of items/records associated with a particular item/record selected by the user. The sample in this article uses a table with a one-to-many relationship with a second table. A list box displays one field from the "one-sided" table, and shows all the records associated with that item. This may be referred to as a Master/Detail relationship, or a one-to-many form.

Specifically, this sample puts a list of Authors in a drop-down list box. When you choose an author, the books written by that author are populated into a bound grid Design-time control (DTC). It uses the Authors table from Pubs to populate the list box and the TitleAuthor table to populate the books by that author into the grid.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top