me.dropdown in a subform

  • Thread starter Thread starter Rick B
  • Start date Start date
R

Rick B

Hello all. I have an invoice form with a a subform for the invoide details.
The first field in the subform is basically a combo-box containing the
various part numbers available in the database. I want that combobox to
drop down when the user enters it. This way they can use the arrows to move
from one product to another if the beginning of the item is similar.
Currently they must use the mouse to drop it down.

I tried adding Me.PartCmbo.DropDown in the field's got focus and on enter
events. In each case, as soon as the form is openeing, the field is
"dropped down". Even though the cursor is in the main form, not the
subform. When I tried to do it in the field's click event, it did not drop
down at all (if I remember correctly) and that event would still cause the
user to grab the mouse.

I could apply this code in the "lost focus" event on my main form, but my
user could potentially jump around the fields in a different order.

Anyone have any ideas? This form is almost identical to the Northwind's
"Orders" form. The "Product" field is the one I am trying to drop-down.

If this can't be resolved, is there a keyboard shortcut while in the field
that will cause the list to drop down?

Thanks!!
 
Rick said:
Hello all. I have an invoice form with a a subform for the invoide details.
The first field in the subform is basically a combo-box containing the
various part numbers available in the database. I want that combobox to
drop down when the user enters it. This way they can use the arrows to move
from one product to another if the beginning of the item is similar.
Currently they must use the mouse to drop it down.

I tried adding Me.PartCmbo.DropDown in the field's got focus and on enter
events. In each case, as soon as the form is openeing, the field is
"dropped down". Even though the cursor is in the main form, not the
subform. When I tried to do it in the field's click event, it did not drop
down at all (if I remember correctly) and that event would still cause the
user to grab the mouse.

I could apply this code in the "lost focus" event on my main form, but my
user could potentially jump around the fields in a different order.

Anyone have any ideas? This form is almost identical to the Northwind's
"Orders" form. The "Product" field is the one I am trying to drop-down.

If this can't be resolved, is there a keyboard shortcut while in the field
that will cause the list to drop down?
Click to expand...


The combo box's GotFocus event should work. Maybe you have
some code or something in the main form that's transfering
the focus into the subform???

The keyboard shortcut for dropping a combo box is
Alt + DownArrow
 
Back
Top