Re: odd focus behaviour

"TonyT" <TonyT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:C37244D8-0009-4DCF-9CB2-77115AD69407@xxxxxxxxxxxxxxxx
I have a form that has a combobox that allows the user to select an existing
customer. The afterupdate code sets the rowsource for a second combobox,
makes it visible & sets the focus to said 2nd combobox, BUT, without an error
the focus disappears from any control on the form (the only open form) &
pressing Tab elicits just a 'donk' error sound & focus remains nowhere to be
seen.

Stepping thru the code it works just fine, only at runtime does it fail,
seemingly trying to set the focus whilst requerying or making the second
combobox visible. This works fine on many other OS & office combinations, but
failed today on install on a vista home + office 2007 pro pc, all references
are in place, but I'm wondering if one is corrupt, anyone know which dll
affects focus?


Would you mind posting the code involved? Maybe there's something there that explains what's happening. The only thing I can think of is a hidden error dialog of some sort.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

.

Relevant Pages

  • RE: Difficulty with form design
    ... I'm working with diagnoses and problems and need to track this ... information based on a case by case basis (patients). ... The first combobox would list broad caterogies of diagnoses (ie: ... So that now when I change the first combobox, the second combobox ...
    (microsoft.public.access.forms)
  • Re: Code for cascading box
    ... Perhaps the form doesn't "know" the second combobox has had its RowSource ... which has no row source set. ...
    (microsoft.public.access.modulesdaovba)
  • Re: New To Access and having trouble with synchronized fields
    ... You need three queries for your combobox. ... the query is based on ... Put the following code in the Enter event of the second combobox: ... get cascading information for categories, equipment, and levels. ...
    (microsoft.public.access.forms)
  • Re: pico, nano, micro and Java
    ... Part of the specification for the bean states tnat the user must be able to select values ranging from 100 picofarads up to 1 ... For ease of use purposes, the input is supposed to involve something like a combobox or a spinner or a slider, or something like that, with clearly delineated default values, which the user can then customise. ... So, for testing purposes, I have a combobox containing the numbers 1 to 10, and a second combobox that allows you to select your unit. ...
    (comp.lang.java)
  • Re: ComboBox Problems
    ... 'Filling second combobox ... Dim j As Integer ... Loop ...
    (microsoft.public.excel.programming)