Select Next Recordsource On Key Down from Combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Tahlmorrah said:
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.
Click to expand...


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.
 
Ok they key combination sequence works. Now how do I assign the Alt +
DownArrow to the On Key Down even procedure?

Marshall Barton said:
Tahlmorrah said:
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.
Click to expand...


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.
Click to expand...
 
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?
--
Marsh
MVP [MS Access]


Ok they key combination sequence works. Now how do I assign the Alt +
DownArrow to the On Key Down even procedure?

Tahlmorrah said:
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.
Click to expand...
Click to expand...
Marshall Barton said:
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.
Click to expand...
Click to expand...
 
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.

Marshall Barton said:
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?
--
Marsh
MVP [MS Access]


Ok they key combination sequence works. Now how do I assign the Alt +
DownArrow to the On Key Down even procedure?

Tahlmorrah wrote:
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.
Click to expand...
Marshall Barton said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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.
--
Marsh
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
next recordsource from the combo box. I looked up all references for DropDown
and could not find any pertinant information.

Marshall Barton said:
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?

Ok they key combination sequence works. Now how do I assign the Alt +
DownArrow to the On Key Down even procedure?


Tahlmorrah wrote:
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.


:
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.
Click to expand...
Click to expand...
Click to expand...
 
Danke, knew it had to be easy.

Marshall Barton said:
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.
--
Marsh
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
next recordsource from the combo box. I looked up all references for DropDown
and could not find any pertinant information.

Marshall Barton said:
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?


Tahlmorrah wrote:
Ok they key combination sequence works. Now how do I assign the Alt +
DownArrow to the On Key Down even procedure?


Tahlmorrah wrote:
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.


:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top