Combo Box - not able to select option?

[Guest]

Hi everyone,
I have a combo box in an unbound form that is controlled by table1. I do
not have a control source as I do not wish to populate with this data, but
need it to hold the data in order to determine what other fields may be
available on the form. I currently have the following code in my row source:
SELECT Item_Type.Item_Type_Description FROM Item_Type GROUP BY
Item_Type.Item_Type_Description;
and I can see the options in the drop down, however, whenever I click on one
of them, nothing happens and I cannot get the combo box to update.
Any ideas? Thanks!
-gary

 

[Jeff Boyce]

Gary

Why are you using "GROUP BY"?

What happens if you leave that part out?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi Jeff,
Thanks for the reply. I need the group by as the table actually has
duplicate entries that I do not always want to appear in the selection.
However, even pulling out the GROUP BY - I still cannot make a selection. I
can see all the options when I select the arrow, but I cannot click on one to
stay in the field.
Thanks!
-gary

 

[J. Goddard]

Is the "Locked" property of the combo box (incorrectly) set to "Yes"?

john

 

[Jeff Boyce]

Gary

I wonder if your issue is due to the GROUP BY. If you use aggregation,
Access wouldn't know WHICH record to update, since you've grouped them.

Do you have an alternate way to identify the correct record? If you have
true duplicates, why? If your data isn't clean, how can you identify which
of the duplicates is the "right" one?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi John,
Yea, that did it. Thank you so much and sorry for not looking into this all
the way.
-gary

 

[Guest]

Hi Jeff,
I do need the GROUP BY as I am only wanting to see the fields and I am not
updating the table I am pulling the fields from, so in a sense, they are all
correct. Once this is determined, I will use it to set up the next group of
selections. A completely different table will then be updated.
In regards to the table having the identicle fields, this is also needed due
to the data being used. Sorry to be so vague, but to explain it would be
brutal!
Thank you so much!
-gary