Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Make Combo-box drop down using code

Posted on 2000-03-12
3
Medium Priority
?
264 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
BrianWren earned 400 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

636 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