listbox and textbox issue

[bluesage]

hi,

im trying to do the following but need help:

1.) i have a listbox containing 4 values, lets say bob, frank, sara, tara

2.) i have a textbox with no value, but i want it to show a specific value from the listbox. example:

i want the txtbox to show bob.

3.)

if tried this:

= [listboxname.value(0)]

but doesnt work?

what i need to do is:

im going to have two forms. one with the listbox of names.
on a second form, i want to display the names in different txtboxes. so i would have four in this case, each one showing a different name.

but dont know how?

thanks

 

[PHV]

Try something like this:
For i = 0 To 3
MsgBox Forms!yourMainForm!listboxname.Column(0, i)
Next i

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244