Very Computer

by **Bazzel Brus** » Sun, 11 Oct 1998 04:00:00

I have a DBList on a form that links to an ISGData (ADO 2.0) control.
That's fine and it displays what I want but I would like to be able to
select an item in the list (say employee fullname - thats made up of first
name and last name from the db) and then display the rest of the data that
is associated for that record in other text fields on the form.

How do you determine what item number (similar to the itemindex with the
list
control) has been clicked as to then move the record controler to the
corresponding record in the recordset?

Can anyone help

by **Robert Malikia** » Mon, 12 Oct 1998 04:00:00

Use a sql to call the data for you.
Text1.Text = ""
.......
for all other data boxes.
then do a sql
sqlQuery = "select * from DATADBASENAME where [filedName] = "DBList.text" or
some thing like this
then execute the sql

Quote:>I have a DBList on a form that links to an ISGData (ADO 2.0) control.
>That's fine and it displays what I want but I would like to be able to
>select an item in the list (say employee fullname - thats made up of first
>name and last name from the db) and then display the rest of the data that
>is associated for that record in other text fields on the form.

>How do you determine what item number (similar to the itemindex with the
>list
>control) has been clicked as to then move the record controler to the
>corresponding record in the recordset?

>Can anyone help

Very Computer

Help with DBList_Click()

Help with DBList_Click()

Help with DBList_Click()