 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / August 2005Select Next Recordsource On Key Down from Combo box
Quite sure I am just experiencing an ID-10-T error when trying to figure out how to do this. Have combobox with Row Source of SELECT [Participant].[Name] FROM Participant; It automatically selects the top record of the correct table What I would like to do is use the On Key Down Event to select the next record from the row source Sounds simple enough, but can not figure out how to do it..and MS Help Files are so much help. Thank you in advance. >Quite sure I am just experiencing an ID-10-T error when trying to figure out >how to do this. [quoted text clipped - 6 lines] >Sounds simple enough, but can not figure out how to do it..and MS Help Files >are so much help. Not sure I understand, but there are shortcut keys that might do what you want. Alt + DownArrow drops the combo's list and, once that is done, DownArrow moves down the list one item at a time.  SignatureMarsh MVP [MS Access] Ok they key combination sequence works. Now how do I assign the Alt + DownArrow to the On Key Down even procedure? > >Quite sure I am just experiencing an ID-10-T error when trying to figure out > >how to do this. [quoted text clipped - 13 lines] > done, > DownArrow moves down the list one item at a time. Why? You want to drop the list automatically? If so you can use the DropDown method. I think I'm missing something here. If the down arrow key already does what you want, why bother with the KeyDown event? SignatureMarsh MVP [MS Access] >Ok they key combination sequence works. Now how do I assign the Alt + >DownArrow to the On Key Down even procedure? [quoted text clipped - 16 lines] >> done, >> DownArrow moves down the list one item at a time. The down arrow does not do what I want. By default it select the next field in the tab order stop. I would prefer on this one field for it to select the next recordsource from the combo box. I looked up all references for DropDown and could not find any pertinant information. > Why? You want to drop the list automatically? If so you > can use the DropDown method. [quoted text clipped - 22 lines] > >> done, > >> DownArrow moves down the list one item at a time. Just use this in the combo box's Enter event procedure: Me.combobox.DropDown so when the user user the down arrow (or Tab, etc) to navigate to the combo box, it immediately drops down and the next down arrow moves through its list. SignatureMarsh MVP [MS Access] >The down arrow does not do what I want. By default it select the next field >in the tab order stop. I would prefer on this one field for it to select the [quoted text clipped - 28 lines] >> >> done, >> >> DownArrow moves down the list one item at a time. Danke, knew it had to be easy. > Just use this in the combo box's Enter event procedure: > [quoted text clipped - 35 lines] > >> >> done, > >> >> DownArrow moves down the list one item at a time. What does the Me mean in the expression Me.combobox.DropDown I get an error that a Macro can't be found. Do I need to set something else up first? > Danke, knew it had to be easy. > [quoted text clipped - 37 lines] > > >> >> done, > > >> >> DownArrow moves down the list one item at a time. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.