combo box or list box ??

  • Thread starter lambertsm via AccessMonster.com
  • Start date

L

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
 
Ad

Advertisements

Ad

Advertisements

L

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top