Combo Box Form With One Entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a form to populate a table, and am using a combo box with a drop
down to select the value and then the value selected populate the desired
field in the table. When I use a list box to populate a field, it won't
populate, so I am forced to use a combo box, select the entry I want, and
then push it to the table. I would like to accomplish one of two things:

1. Find a way to use the list box and successfully have the data populate
table (it currently won't)
2. Find a way to have the combo box populate automatically without needing
to hit the drop down.

There is only one value that shows up in the combo box, which is what I
want. I realize this goes against the need to use a combo box, but I am
forced to because the list box option won't work.

Any ideas on what I am doing wrong with the list box that keeps it from
populating the table when a combo box will?

Thanks,

Shane
 
Shane said:
I am using a form to populate a table, and am using a combo box with
a drop down to select the value and then the value selected populate
the desired field in the table. When I use a list box to populate a
field, it won't populate, so I am forced to use a combo box, select
the entry I want, and then push it to the table. I would like to
accomplish one of two things:

1. Find a way to use the list box and successfully have the data
populate table (it currently won't)
2. Find a way to have the combo box populate automatically without
needing to hit the drop down.

There is only one value that shows up in the combo box, which is what
I want. I realize this goes against the need to use a combo box, but
I am forced to because the list box option won't work.

Any ideas on what I am doing wrong with the list box that keeps it
from populating the table when a combo box will?
Click to expand...

The only thing I can think of that distinguishes a list box from a combo
box, as far as bind to fields is concerned, is the list box's
MultiSelect property. If the list box's MultiSelect property is set to
anything other than "None", its value is always Null, no matter how many
items are selected from the list. So make sure your list box's
MultiSelect property (on the Other tab of the control's property sheet)
is set to "None", and that its ControlSource property is set to the
field you want to store its value in, and it ought to work as well as
the combo box does.

I don't understand why you would want to use a combo box *or* a list
box, if there will only ever be one item in it.
 
Normally when you use the wizard to create a listbox it
asks, which table/query provides the value for your
listbox, then after selecting that, it gives you two
options as of what to do with the value of that
listbox...either remember or store...........when
selecting store, just enter the field you want it stored
in andshould automatically populate the field you meant it
for
 
Back
Top