Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

combobox dropdown

Status
Not open for further replies.

matrixindicator

IS-IT--Management
Sep 6, 2007
418
BE
I have seen an example of the method dropdown (open) a combobox, but it seem to work only if the combobox has the event GotFocus.
Code:
me.cboFirst.dropdown
Is the next possible ? I have a first combobox, he limit the selected records in the next combobox. To make it more understandable.
first combobox select "warehouses".
second combobox select any houses of the type warehouses (this works).
When the first selection is done, open the second combobox (dropdown automatically), how to ?


 
On the AfterUpdate event of the first combobox, put:
Me![SecondComboname].Setfocus
Me![SecondComboname].Dropdown
 
Make sure you dont have a message box AFTER the dropdown or the dropdown will be closed for the message box.

Spent 15 minutes trying to figure out why the box was not opening and I came here to confirm that yes I did know what I was doing.....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top