Solved

opposite of .dropdown

Posted on 2007-11-18
6
625 Views
Last Modified: 2008-02-01
hello,

how to close a combobox with code?

thanks!
0
Comment
Question by:Moother
  • 3
  • 2
6 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 300 total points
ID: 20307614
set the focus to other control.

me.othercontrolname.setfocus

the dropdown automatically hides once the combo box lost the focus
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 300 total points
ID: 20307618
to clear a combo selection
me.comboname=""
0
 
LVL 10

Assisted Solution

by:LennyGray
LennyGray earned 200 total points
ID: 20307679
as soon as you click your mouse, whether by selecting somethingfrom the combobox or when you click on another control the combobox closes.

In what instance does the combobox stay open in your application where you need ot to close?
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 3

Author Comment

by:Moother
ID: 20311003
@ lenny...

i have .dropdown on OnChange... when i click-select a value the combo doesnt close....

.dropdown is nice but not if it stays irritatingly open!
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 300 total points
ID: 20311918
moother

try moving the codes in the enter or focus event of the combo.
0
 
LVL 10

Assisted Solution

by:LennyGray
LennyGray earned 200 total points
ID: 20312081
is the OnChange Event a form event or a control event? Under what circumstances exactly do you want the combobox to drop down?
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

809 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