Listbox/Database

I have several text boxes that show the info from a database, also I have a list box thats populated from one of the database fields. When the item is selected in the Listbox I need to show the info for that record in the text boxes.

Also when I delete a record from the text boxes how can I make it delete from the listbox.

I hope I made myself clear, its sometimes hard to put things in words.

thanks,

JO

i just did the same thing, use the bookmark property.

adControl.Recordset.BookMark = Datalist.SelectedItem

I didn't know about the bookmark property, Thanks.

I'm getting an error telling me the

"Method or data member not found"

for .SelectedItem property. Any ideas?