Combo Box won't accept selection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

G - 30 Mar 2005 06:51 GMT

I have made a simple combo box, based on one field in a table (category)
the sql for row source brings up the correct data, the row source shows the
correct data, but nothing happens when I click on anything in the row source.

What is causing this and how can I fix it?

Signature

Thank you in advance for your assistance. It is greatly appreciated.

G

Reply to this Message

Helen - 30 Mar 2005 08:46 GMT

G did you want the combo box to be bound to a field in a table, eg.
category? If that's the case you'll need to check the Control Source
property of your combo box and make sure it says the field name there.

As a matter of interest, did you use the wizard to create your combo box?
Sometimes that's the easiest way, then edit the Record Source afterwards, to
customise your list.
regards, Helen

>I have made a simple combo box, based on one field in a table (category)
> the sql for row source brings up the correct data, the row source shows
[quoted text clipped - 3 lines]
>
> What is causing this and how can I fix it?

Reply to this Message

G - 31 Mar 2005 00:25 GMT

Helen,
I've tried bound/unbound. Yes, I used the wizard, and yes, I modified the
query to exclude the autonumber and only select distinct. It still won't work.
The drop down list from the recordsource is fine, but nothing happens if I
select anything in the list.
G

> G did you want the combo box to be bound to a field in a table, eg.
> category? If that's the case you'll need to check the Control Source
[quoted text clipped - 12 lines]
> >
> > What is causing this and how can I fix it?

Reply to this Message

Jeff Conrad - 31 Mar 2005 00:41 GMT

If a form's Allow Edits property is set to "No", this makes
selection in a combo box (bound or unbound) impossible
on the form. Go to the form's Properties list and change
Allow Edits to "Yes" and then you will be able to select
a value from the combo box.

Signature

Jeff Conrad
Access Junkie
Bend, Oregon

> Helen,
> I've tried bound/unbound. Yes, I used the wizard, and yes, I modified the
[quoted text clipped - 19 lines]
> > >
> > > What is causing this and how can I fix it?

Reply to this Message