Listbox

[joltremari]

I'm getting an error when I try and use the List1.Selected property - "Argument not optional"

I've used it before. What will cause this?

Thanks,

JO

[HeSaidJoe]

your code = ???

[joltremari]

Oops!

Private Sub List1_Click()
Data1.Recordset.Bookmark = List1.Selected
End Sub

[mpSmooth]

Try this:

Dim aBookMark as variant
aBookMark = data1.recordset.bookmark



**Add this when you want to go back to that bookmark
data1.recordset.bookmark = aBookMark

Also, what your trying, i tried the same code with the datalist, except I used the SelectedItem. adExample.Recordset.Bookmark = datalist.SelectedItem

try using the text property

[Edited by mpSmooth on 11-21-2000 at 10:33 AM]

[MartinLiss]

I think you simply want to do this, which will select the 3rd item in the list (zero selects the 1st item):

List1.Selected(2) = True

[joltremari]

None of this seems to be working for me. Let me give you a little more detail...(im new to databases)
I have a from with several text boxes, each linked to a field in a database.

I have a Listbox that populates at form_activate with the contents of a database field:

While Not Data1.Recordset.EOF
List1.AddItem Data1.Recordset!Name
Data1.Recordset.MoveNext
Wend

What I am trying to do is when I click on a name in the list box I need it to show that record in the text boxes on my form.

[mpSmooth]

why not use the datalist box that comes with vb. It's located in the components sections. Nevermind, sorry, I just realized that you are using the standard control. I'll see what I can come up with.

[Edited by mpSmooth on 11-21-2000 at 11:52 AM]