(List box) for Access/Form. I can create one,doesn't work right

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Question on Creating a List Box - 19 May 2006 20:27 GMT

Ok, I know how to make a list box (or maybe I don't)? What I want to
achieve... I want to make a list box or pop-up box that will list working
locations where our employees report to. I have a database already in place
that has 1,000 records of employees and I want to create a list box which
show locations for example; Brooklyn, Cleveland, Chicago etc. I want to be
able to click on just (1) of the many locations listed in the list box, and
choose the correct working location for each employee, each record. Problem
is, is that when I can create a list box, it doesn't work right. I've made
my list in "Table", the field is called "Locations". Then I'm in "Form",
design view. I let the "Wizard" help. I've created the list box but it
doesn't work right, so obviously missing an important step. Would appreciate
your response.

Reply to this Message

Jeff L - 19 May 2006 20:42 GMT

What isn't working right about it? What are you expecting it to do
that it's not doing?

Reply to this Message

Klatuu - 19 May 2006 20:56 GMT

Since you only want to select one location, why are you choosing to use a
list box rather than an combo? A combo is much easier to control and can do
anything the list box does. The reason it is called a combo box is it is a
combination of a text box and a list box.

> Ok, I know how to make a list box (or maybe I don't)? What I want to
> achieve... I want to make a list box or pop-up box that will list working
[quoted text clipped - 8 lines]
> doesn't work right, so obviously missing an important step. Would appreciate
> your response.

Reply to this Message