automatic drop down lists

  • Thread starter Thread starter Phil R
  • Start date Start date
P

Phil R

Hi
I'm trying to make the list in a combobox dropdown
automatically when I Tab to the control.

I can get this to work on the main form using SENDKEYS "%
{DOWN}" in the On Enter property, but I can't make it work
in a subform.

What do I need to do?
 
Hi,
IN the Enter event of each combo, put this code:
Me.nameOfCombo.Dropdown

Substitute the correct name.
 
I tried your suggestion but I got an error message saying
can't find the macro ME

this is the code I entered in the ENTER event.
Me.disability.dropdown
disability is the name of the combo.
The combo is on a sub form of a sub form.
ie Forms!ParentForm!ParentForm!SubForm!disability
What am I doing wrong? I'm using Access 97
-----Original Message-----
Hi,
IN the Enter event of each combo, put this code:
Me.nameOfCombo.Dropdown

Substitute the correct name.

--
HTH
Dan Artuso, Access MVP


"Phil R" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Back
Top