Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

select item in listbox via VBA in form onload event

Posted on 2010-01-04
6
Medium Priority
?
1,725 Views
Last Modified: 2013-12-05
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.
0
Comment
Question by:jvantassel1
  • 3
  • 3
6 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 26171191
this will select the first item in the listbox
me.ListboxName.value=me.listbox.itemdata(0)  
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 26171193
this will select the first item in the listbox
me.ListboxName.value=me.listboxname.itemdata(0)  
0
 
LVL 1

Author Comment

by:jvantassel1
ID: 26172117
It is in this case
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 26172154
is this what you are after?
0
 
LVL 1

Author Comment

by:jvantassel1
ID: 26172771
This didn't work.  I'v attached a print screen.  I want the first row of 'Limit by TDA:' selected.
Report-Tool.bmp
0
 
LVL 1

Author Closing Comment

by:jvantassel1
ID: 31672384
This works.  Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question