combo box or list box ??

[lambertsm via AccessMonster.com]

I have a list box control on my form that looks up brand name in a table.
This list box then has some code that looks up that brand and fills in the
rest of the form. I choose a list box because I didn’t want the user to be
able to edit any of the data in this control. (Turning GE into GM or some
other similar disaster.) The problem is my users are complaining because it
is a big list and they are little arrows and it doesn’t give them a drop down
menu. I could make the control bigger but like I said it is a big list so it
looks pretty daunting and I don’t have a lot of room on the form. I tried
programming in Me![ListboxName].Dropdown for the OnEnter event but I got an
error that it wasn’t supported for that object. I would use a combo box but
when I have done that before I couldn’t figure out how to set it up so that
the users could both select something in the box (and thus fill in the rest
of the form) but wouldn’t be able to edit it. So I need to know how to
either:
1. Make a list box more user friendly, with a drop down box or bigger
arrows or something. OR
2. Make a combo box where users can select a record but they can’t edit
that record.

Can I get the best of both words in a combo box and a list box?

Shauna

 

[Douglas J. Steele]

Set the combo box's LimitToList property to True.

 

[lambertsm via AccessMonster.com]

That makes perfect obvious sense. Worked great! Thanks!

Set the combo box's LimitToList property to True.

I have a list box control on my form that looks up brand name in a table.
This list box then has some code that looks up that brand and fills in the

[quoted text clipped - 26 lines]

Shauna