Solved

Make Combo-box drop down using code

Posted on 2000-03-12
3
215 Views
Last Modified: 2011-09-20
Can I make a combo-box "drop- down" by using code? Like it does when the "select and item from the list" message appears after the notintlist event?
0
Comment
Question by:pbetts
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
BrianWren earned 100 total points
ID: 2610835
In code for the form with the combo on it, (let's say it's called cboData), use

     Me!cboData.Dropdown

If the combo is on a form and the code is not part of that form, (let's say the form is called frmData), use

    Forms!frmData!cboData.Dropdown

If the cobo is on a subform, and the code is part of the main form, and the control with the subform in it is called ctrlSubform, use

    Me!ctrlSubform.Form!cboData.Dropdown

Brian
0
 

Author Comment

by:pbetts
ID: 2610960
Thanx Brian...much appreciated
cheers from Oz
0
 

Author Comment

by:pbetts
ID: 2610964
hmmm... that was supposed to be 100points Brian..i'll have to throw you a lollly for another 90 :)
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now