Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > access > answers

Combobox dropdown

Alireza355's Avatar
Member
  
Join Date: Feb 2009
Location: Iran
Posts: 68
#1: 2 Weeks Ago
Dear all,

I have a combobox, which shows some records from a query in the combobox rowsource.

I want the combobox to dropdown whenever it receives focus from the previous field, so that the user becomes familiar with the information that has already been entered by previous users in the past...

I would appreciate your assistance.

Thank you so much.
msquared's Avatar
Administrator
  
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,865
#2: 2 Weeks Ago

re: Combobox dropdown

Put the following code in the "On Enter" event of the combobox

Expand|Select|Wrap|Line Numbers
  1. Me.ComboboxName.Dropdown
  2.  
msquared's Avatar
Administrator
  
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,865
#3: 2 Weeks Ago

re: Combobox dropdown

Small change, it might be better to change it to the "Got Focus" event.
Alireza355's Avatar
Member
  
Join Date: Feb 2009
Location: Iran
Posts: 68
#4: 1 Week Ago

re: Combobox dropdown

Thanx a lot.

It worked perfect...

Best Regards,
Alireza355
msquared's Avatar
Administrator
  
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,865
#5: 1 Week Ago

re: Combobox dropdown

Quote:

Originally Posted by Alireza355 View Post

Thanx a lot.

It worked perfect...

Best Regards,
Alireza355


You're Welcome :)
Reply

« previous question | next question »

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,295 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved