select item in listbox via VBA in form onload event

I have a list box and I want a row selected on the when the form is opened.
The first column shows the same value in each row while the values in the second column are differerent.
LVL 1
jvantassel1Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
this will select the first item in the listbox
me.ListboxName.value=me.listboxname.itemdata(0)  
0
 
Rey Obrero (Capricorn1)Commented:
this will select the first item in the listbox
me.ListboxName.value=me.listbox.itemdata(0)  
0
 
jvantassel1Author Commented:
It is in this case
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Rey Obrero (Capricorn1)Commented:
is this what you are after?
0
 
jvantassel1Author Commented:
This didn't work.  I'v attached a print screen.  I want the first row of 'Limit by TDA:' selected.
Report-Tool.bmp
0
 
jvantassel1Author Commented:
This works.  Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.