Drop Down Menu Auto Load on form?

[yepwingtim]

Right when I type something, I want the dropdown menu to appear instead of clicking on the arrow

This is because I have 2 fields in the dropdown menu (Last Name, First Name)

I can only see the Last Name Auto Completed. I have to have to click on the arrow thing to see the First Name.
________
Airsoft Cyma

 

[dkinley]

As far as I know, that is the way they work. I've gotten around it by concantenating two columns ([LastName] & ", " & [FirstName]).

Of course, this is in the macros section and I don't know anything about those.

HTH,
-dK

 

[pbaldy]

You can drop down the combo in the got focus event with:

Me.ComboName.DropDown

if that's what you're looking for.

 

[yepwingtim]

thanks pblady - should of used search first
________
Sixteen