I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

December Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardAccess VBA Programming Topic   Print This     

Combo Box won't update with specified value

Combo Box won't update with specified value in Access VBA Programming topic (part of our Microsoft Access group).

Quick Search: won't   specified   Combo Box   Combo Box won't   update specified  
Craig Goodman
Basking Ridge, NJ USA

As this is my first post to this board, I will try not to complicate this with unnecessary information.

I am trying to set a combo box to a specific value (the name of a loan) using VBA for when the form opens. The combo box is populated with Loan Names from an Access table. Currently, I am using the following code to set the list index property (I have used this with excel vba before and it worked):

 

Combo_LoanName.ListIndex = 3

 

The problem is that when the form opens the combo box list is populated but no item is selected. I have tried other variations of the code above but to no avail. Can anyone spot what I may be missing?

 

Thanks,

Craig

 Posted 12 years ago (Thread Starter)
Comment Quote
About Craig Goodman -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #12034, 2 replies
Thread Started 8/7/2007 4:13:38 PM
View Counter=4266
Last Reply Posted 2/28/2017 2:33:43 AM)
Location=Basking Ridge, NJ USA 
Joined=12 years ago   MB Posts=2  
Most Recent Post
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA

Thanks for posting the follow up. It's nice when visitors ask and answer their own questions!

Take care,

--
Mike Prestwood
Prestwood IT Solutions

 Posted 12 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #12040 (Level 1.1)  Reply to 12034
Thread Started 8/8/2007 3:38:50 PM
View Counter=2
Location=Prestwood IT office in Citrus Heights, CA 
Joined=19 years ago   MB Posts=1410   KB Posts=1805   KB Comments=69   BLOG, Topics=4  
Craig Goodman
Basking Ridge, NJ USA

I found something that worked! Inserting the following line before setting the list index property did the trick: 

 

Me.Combo_LoanName.SetFocus

 

- Craig

 Posted 12 years ago (Thread Starter)
Comment Quote
About Craig Goodman -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #12037 (Level 1.2)  Reply to 12034
Reply Posted 8/8/2007 10:27:58 AM
Location=Basking Ridge, NJ USA 
Joined=12 years ago   MB Posts=2  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1125A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #12034 Counter
4266
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech