Combo Box

[Kyhigh]

I have form in which I want to have a combo box. I wanted to avoid a query
and asked this question awhile back. Fred responded with a line of script
which looks like this when I put in my table and field names.

SELECT DISTINCT main.[priority] FROM main ORDER BY main.[priority]

I put this in the row source of the combo box. One of three choices should
appear in the drop down list: low, medium, and high. They do not appear, but
when I type the first letter of any of the three choices, the field fills
with that word.

What am I missing to make the drop down box appear with these choices?

 

[fredg]

I have form in which I want to have a combo box. I wanted to avoid a query
and asked this question awhile back. Fred responded with a line of script
which looks like this when I put in my table and field names.

SELECT DISTINCT main.[priority] FROM main ORDER BY main.[priority]

I put this in the row source of the combo box. One of three choices should
appear in the drop down list: low, medium, and high. They do not appear, but
when I type the first letter of any of the three choices, the field fills
with that word.

What am I missing to make the drop down box appear with these choices?

1) What is the bound column property number value of the combo box?
It should be 1.
2) What is the Column Widths property value?
It should be something like this:
1"
(any number except 0".
3) What version of Access are you using?
If perhaps it is Access 2003 and you have installed Service Pack it
could be the Service Pack 3 bug.
See this link for details on the hotfix.

http://support.microsoft.com/kb/945674