Re: Combo Boxes - KeyDown/AfterUpdate/Lost focus interactions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

To have the arrow keys navigate up and down the drop down list doesn't
require any code once the list is open, the normal behavior is to navigate
up and down the list. To open the list, you can use Alt+Down Arrow. If you
wanted to bypass using the Alt key, you could use the key down event to
check for the down arrow key and if the drop down wasn't open, then open it,
otherwise do nothing. To see if the drop down is already open you could use
the code form this link.

http://www.mvps.org/access/api/api0052.htm

--
Wayne Morgan
MS Access MVP


"Ed Ardzinski" <Ed_Ardzinski_NO_SPAM_@xxxxxxxxxxx> wrote in message
news:C5E069BB-199C-472E-B50E-F1C52131EEEE@xxxxxxxxxxxxxxxx
>I inherited this database about 8 months ago, and there were "Lost Focus"
> events after certain fields were entered. In some cases these event would
> interfere with the use of the navigation buttons.
>
> I changed the events to be AfterUpdates, and things went well. Eventually
> I
> put in some KeyDown events on the combo boxes so the users could use the
> up
> or down arrow to navigate the lists. this was all Access 2000
>
> The office is switching to XP/Office 2003, and I am told that the up/down
> arrow code is causing an error, I think it was 777-You've used the
> ListIndex
> property incorrectly...
>
> So to get around it, I eventually went back to the lost focus
> events...which
> calculate and (sometimes) populate other fields in the form. Now I'm back
> to
> getting annoying navigation behavior.
>
> Any thoughts/suggestions/enlightenment would be helpful...thanks all!


.

Relevant Pages

  • Re: WHY doesnt C know anything about directories?
    ... database can be mapped so that every file it contains lies on ... that 2D surface then UP ACROSS and DOWN should be sufficient to navigate to any of those files. ... Lists all tables, ... restrict the specification after one column has been ...
    (comp.lang.c)
  • Re: Navigate to an item in pulldown by typing first couple of letters
    ... drop arrow and it will take you the Cs. ... Click the first icon on the top left (it has a blue "thing" and what looks ... This will put you in design mode. ... menu that lists the list from the sheet A. The list contains 2400+ ...
    (microsoft.public.excel.misc)
  • Re: WHY doesnt C know anything about directories?
    ... since platform-specific extensions do it very well. ... There is a need because it's a PITA to port those platform specific ... Lists all tables, ... Navigate DOWN: List all columns in table, ...
    (comp.lang.c)
  • Re: Newsreader usage in this group
    ... Back arrow 4 times would take you to Job B's post. ... the numeric keypad cluster will navigate ... around the graphical thread regardless of thread path. ...
    (uk.comp.sys.mac)
  • Re: Drop down lists show button?
    ... Catch a 'print-screen' of the small arrow button. ... > Thank you for your help Debra. ... >> Only the active cell can have the data validation arrow visible. ... >>> down lists in one of my worksheets. ...
    (microsoft.public.excel.worksheet.functions)