always expand combo/list box??

[mccaulj]

Is it possible to have the list box portion of a combo box always expanded, not just when you click on it?

I have set up a form with a combo box that has three columns (last name, first name, id#), when you start typing in last name, it fills in matching the name on the list, but since it doesn't show the rest of the info unless the list box is expanded you could be selecting the wrong name before moving on (in an instance where there are two people with the same last name, etc) I want to be able to see all of the info in the three columns before I select it to move out of the control.
Is this possible?? Clicking on it is not efficient when entering multitudes of names. I would like a way for it to be automatic or a keystroke.
Thanks!
J.McCaul

 

[pcs]

if i understand your question, i think you need to look in Help for Dropdown method. you can fire it from the event of your choice..(Gotfocus,etc.)

hth,
al


[This message has been edited by pcs (edited 03-20-2002).]

 

[mccaulj]

THANK YOU!!
I knew there had to be a way. I just wasn't looking under the right things.

J.McCaul

 

[mccaulj]

Ok, it worked the first time. Now, whenever I submit the record and go to next it doesn't in this one field only.

Here's what I have:
Combobox (ID#) set to drop down on "got focus"

some other boxes of info that are working fine

an invisible submit button that is set to go to new record, go to control ID#, on "Enter"

Now the first time through everything works peachy. Then I go to submit the record, it takes me to a new record, sets the focus back to the id# combo box, but it doesn't drop down.
I have played around with all of the different event functions and can't get it to work the second time through.
What am I missing??
Thanks!
J.McCaul

 

[DBL]

Do you have something like this on the submit button:

DoCmd.GotoRecord,,,acnewrecord
Me.combobox.setfocus

?

If you do, add

Me.combobox.dropdown

I'm not sure why it's not dropping down automatically, maybe because you are forcing the focus.

My combo box is the first field in the form so the box has dropped down when the form is first opened and looks really odd. I would rather it dropped as the user starts to type. Does anyone know of a way to delay the drop down until the user starts the selection?