Combo Box won't accept selection

G

G

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?
 
H

Helen

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
 
G

G

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

Helen said:
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
Click to expand...
 
J

Jeff Conrad

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.

--
Jeff Conrad
Access Junkie
Bend, Oregon

G said:
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
Click to expand...
 
Top