UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Combo Box Dropdown, Access 2010    
 
   
rzw0wr
post Mar 5 2018, 01:07 AM
Post#1



Posts: 289
Joined: 28-March 12
From: Indiana


I have a form that has 1 combo box.
A name has to be selected before you can continue to the next form.

Access 2010 32 bit

I would like the combo box to drop down the list when the form opens.

I have tried to use the form current event.
Me.Setfocus
Me,cboSelectName,DropDown

This works untill End Sub happens.

I tried gotfocus on the combo box and it does the same thing.

The list will drop down then go away on the next End Sub.


Thanks,
Dale

--------------------
Access 2010 32 bit.
Not really very good at access.
Go to the top of the page
 
fkegley
post Mar 5 2018, 01:32 AM
Post#2


UtterAccess VIP
Posts: 23,754
Joined: 13-January 05
From: Mississippi


Try using a different event, such as the Load event of the form.

--------------------
Frank Kegley, Microsoft Access 2010 MVP
Go to the top of the page
 
rzw0wr
post Mar 5 2018, 01:37 AM
Post#3



Posts: 289
Joined: 28-March 12
From: Indiana


I have tried OnLoad, OnActive,OnOpen,OnCurrent

They all work until the EndSub.

I have read a few place on the net where others are having the same problem.
Usually when updating from Access2003 or 2007 to 2010.


Thanks for the reply

Dale

--------------------
Access 2010 32 bit.
Not really very good at access.
Go to the top of the page
 
projecttoday
post Mar 5 2018, 01:54 AM
Post#4


UtterAccess VIP
Posts: 10,067
Joined: 10-February 04
From: South Charleston, WV


A listbox would appear much like a dropped-down combobox.

--------------------
Robert Crouser
Go to the top of the page
 
missinglinq
post Mar 5 2018, 08:04 AM
Post#5



Posts: 4,537
Joined: 11-November 02



This is, indeed, a much discussed problem, unsolved for years until a solution was finally posted by one amrut, of Dubai. Replacing ComboName with the actual name of your Combobox:

CODE
Private Sub Form_Open(Cancel As Integer)
  Me.TimerInterval = 1
End Sub

Private Sub Form_Timer()
  Me.TimerInterval = 0
  Me.ComboName.SetFocus
  ActiveControl.Dropdown
End Sub

Linq ;0)>

--------------------
Hope this helps!

The problem with making anything foolproof...is that fools are so darn ingenious!

All posts/responses based on Access 2003/2007
Go to the top of the page
 
HairyBob
post Mar 5 2018, 08:38 AM
Post#6



Posts: 992
Joined: 26-March 08
From: London, UK


Thanks Linq thumbup.gif ... In the past I've wondered why I couldn't get that to work - simply a matter of giving the form a chance to open!

Hairy.
Attached File(s)
Attached File  ComboBoxDropDown.zip ( 21.78K )Number of downloads: 13
 
Go to the top of the page
 
missinglinq
post Mar 5 2018, 09:21 AM
Post#7



Posts: 4,537
Joined: 11-November 02



You're welcome...although the real credit belongs to amrut! My only contribution was being able to find the solution...I currently have nearly 5000 files with hacks that I've either developed myself, or have collected from this or other forums during the 12 years since I've been disabled. The problem is always to find the appropriate file!

Linq ;0)>

--------------------
Hope this helps!

The problem with making anything foolproof...is that fools are so darn ingenious!

All posts/responses based on Access 2003/2007
Go to the top of the page
 
rzw0wr
post Mar 5 2018, 03:41 PM
Post#8



Posts: 289
Joined: 28-March 12
From: Indiana


Ling,
Works great.

Thanks to you for findinf and posting.

Thanks to amrut for finding a fix.


Dale

--------------------
Access 2010 32 bit.
Not really very good at access.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    24th September 2018 - 04:32 AM